You can download the Excel sample data and Power BI file at the bottom of this article if you want to follow along step by step.ĮDIT: I have a big block of M code you can use to create your own date table at this link - it is an Evernote page. And because it is in Power Query, it will be an imported table which is what Power BI loves most, being more efficient than a table created in DAX with calculated columns. The starting and ending dates will move with your data over time. I’m going to show you how to quickly set up a date table in Power Query, one that will be dynamic. Most Power BI and Power Pivot (Excel) reports require a date table so time intelligence functions can calculate correctly.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |