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.
I'm trying to create a date table which only goes back as far as the last 13 calendar months from today and my code does not work, can you show me where i'm going wrong?
Date = CALENDAR(DATE(MONTH(TODAY()-13),1,1),TODAY())
Solved! Go to Solution.
I found a simpler solution which corrected my original syntax
Date = CALENDAR(DATE(YEAR(TODAY()),MONTH(TODAY())-13,DAY(TODAY())),today())
Try:
13 months Cal =
VAR _Today =
TODAY ()
VAR __13Months =
DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 13, DAY ( TODAY () ) )
RETURN
CALENDAR ( __13Months, _Today )
Proud to be a Super User!
Paul on Linkedin.
I found a simpler solution which corrected my original syntax
Date = CALENDAR(DATE(YEAR(TODAY()),MONTH(TODAY())-13,DAY(TODAY())),today())
Interesting solution. I didn't know that using Date() would automatically change the year based on the subtraction of the months 🙂
Try this: Date = CALENDAR(DATEADD(TODAY(),-13,MONTH),TODAY())
Create a Last Refresh column for your report and use that column.
For reference: https://blogs.perficient.com/2022/08/24/how-to-show-last-refresh-date-in-power-bi/
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
58 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |