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.
Hi All
Solved! Go to Solution.
Please try this expression instead.
MonthRange =
VAR startdate =
EDATE ( TODAY (), - 3 )
VAR enddate =
DATE ( MAX ( 'Date'[Year2] ), MONTH ( TODAY () ) - 1, 1 )
RETURN
FORMAT ( startdate, "MMM" ) & "-"
& FORMAT ( enddate, "MMM yy" )
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You need to change the enddate variable too
VAR enddate =
DATE ( MAX ( 'Date'[Year2] ), MONTH ( TODAY () ) - 4, 1 )
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Please try this expression instead.
MonthRange =
VAR startdate =
EDATE ( TODAY (), - 3 )
VAR enddate =
DATE ( MAX ( 'Date'[Year2] ), MONTH ( TODAY () ) - 1, 1 )
RETURN
FORMAT ( startdate, "MMM" ) & "-"
& FORMAT ( enddate, "MMM yy" )
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thank you very much , it work .
i try to do it for April till June 2021 , it does not work.
Qtr Ptrvious=
VAR startdate =
EDATE ( TODAY (), - 6 )
VAR enddate =
DATE ( MAX ( 'Date'[Year2] ), MONTH ( TODAY () ) - 1, 1 )
RETURN
FORMAT ( startdate, "MMM" ) & "-"
& FORMAT ( enddate, "MMM yy" )
may i know where go wrong ?
Paul
You need to change the enddate variable too
VAR enddate =
DATE ( MAX ( 'Date'[Year2] ), MONTH ( TODAY () ) - 4, 1 )
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |