Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good morning,
I would like to have some tips on this scenario:
I need to load a calendar table based on a time range interval which is coresponding to the Max And Min Date of another table.
How you would manage it?
Thanks
Solved! Go to Solution.
@thebigwhite , Based on what I got
You can try like
Date =calendar(Min(Table[Date]),Max(Table[Date]))
or date =calendarauto()
You can use addcolumns on top of it add other calendar columns
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
Appreciate your Kudos.
Are you trying to build a calendar table from scratch based on the date range in your 'fact' table?
There are a lot of ways to do this: Here's one way:
1. Extract the MAX and MIN dates from a dulicate of your FACT Table:
Use the Group By function and extract Max and Min from the date column
Then add two custom columns that identify the start of the month and end of the month for your date range.
EndDate = Date.EndOfMonth([Max Date])
StartDate = Date.StartofMonth([Min Date])
Then use this formula to make a list of all the days between your start date and end date
{Number.From([StartDate])..Number.From([EndDate])}
Remove all the other columns - and expand the list
Change this to Date Format - and you are good to go!
Add whatever extra columns you want to make this a true date table:
@thebigwhite , Based on what I got
You can try like
Date =calendar(Min(Table[Date]),Max(Table[Date]))
or date =calendarauto()
You can use addcolumns on top of it add other calendar columns
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
Appreciate your Kudos.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |