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.
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/
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 |
---|---|
109 | |
100 | |
74 | |
63 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
66 |