Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello All,
I am using CalendarAuto function for creating dynamic date table. Since my data model has 2021 data, this calendar table is getting extended to 2021 (Screenshot #1). I want to change it to calendar function which should only go upto end of the the current year (e.g. 2020 till Dec 31, 2020 and 2021 from Jan 1, 2021).
This is becasue , this calendar is getting used in another 'next month ' query (screenshot#2) . So if its dec 2020, the next month it is considering is Jan -2022.
#1
#2
Solved! Go to Solution.
You could change your Calendar table or that measure. For the Calendar you could use
CALENDAR(DATE(YEAR(TODAY())),1,1), DATE(YEAR(TODAY()),12,31))
or in the measure, you could just use DATE(YEAR(TODAY()),12,31) in place of your EDATE
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You could change your Calendar table or that measure. For the Calendar you could use
CALENDAR(DATE(YEAR(TODAY())),1,1), DATE(YEAR(TODAY()),12,31))
or in the measure, you could just use DATE(YEAR(TODAY()),12,31) in place of your EDATE
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks for the response . This worked.
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |