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.
13 months Cal = VAR _Today = TODAY () VAR __13Months = DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 13, DAY ( TODAY () ) ) RETURN CALENDAR ( __13Months, _Today )
Create a Last Refresh column for your report and use that column.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.