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.
Hello Everyone,
Can anyone help me with creating a new table that starts with today's date every time I refresh the report.
I want to build this because I don't want unwanted dates starting from tomorrow in the Date slicer and I should be able to use between function within the slicer.
I tried creating a new column with below-given code in a table known as calendar (generated with calendarauto( ) dax) but then I can't use between a function within the slicer. This code is creating a new column within the calendar table, leaving the date starting from tomorrow as blank.
Solved! Go to Solution.
Hi @Anonymous
Bit confusing, you asked for a calendar that starts with today's date but you mean ending with today's date.
Cal = CALENDAR(DATE(2015,1,1), TODAY())
Regards
Phil
Proud to be a Super User!
Hi @Anonymous
Bit confusing, you asked for a calendar that starts with today's date but you mean ending with today's date.
Cal = CALENDAR(DATE(2015,1,1), TODAY())
Regards
Phil
Proud to be a Super User!
Did you try to use CALENDAR this way instead of CALENDARAUTO?
NewDateTable = CALENDAR(TODAY(), DATE(2021,12,31)) // put whatever end date your want or calculate it dynamically from your fact table
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi Pat,
I tried the code it didn't work.
I want to create a calendar table which starts 01/01/2015 and ends today.
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |