Adding a calendar table to your report is essential for Dataverse data because of the nature of our transactional date-stamped data. Almost every report will use some form of a date filter, or a date-based grouping. - Having a flexible and standardized calendar makes all aspects of building the semantic model easier. -
There are many, many variations on calendar tables, but I personally like the one available via the free BRAVO.BI tool available from: https://bravo.bi - it's produced by the amazing team at SQL.BI and lets you add the calendar quickly and easily with many of the common tasks automated for you.
This is a multi-part series where I show you how to create a Self-Service Semantic Model in Fabric, following the best practices to maximize the benefits for your users.
I'm breaking it down into easy-to-follow steps allowing you to either follow with my example model or build your own.
#dataverse #dynamics365 #dynamics365crm #fabricators #microsoftfabric #powerbi #fabric
Watch video 4. Building a Dynamics 365 Self Service Report in Fabric - Part 4 Adding a Calendar online without registration, duration hours minute second in high quality. This video was added by user Scott Sewell 29 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 238 once and liked it 2 people.