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.
@Anonymous this was a great post put on by you which I have used. I rolling 13 months. I need the data to be a Rolling 12 months.
How can I do this please?
Can @Anonymous or anyone else help?
This is the link - https://community.powerbi.com/t5/Desktop/Rolling-13-months-DAX/td-p/663677
Thanks
Solved! Go to Solution.
Hi @Anonymous ,
Please update the measures like this.
2Sales Rolling 12 ACT =
VAR Maximum_Date =
MAX ( 'Rolling Calendar'[Date] )
VAR Minimum_Date =
EDATE(Maximum_Date,-11)
VAR Selected_Date =
MAX ( 'Calendar'[Date] )
RETURN
IF (
Selected_Date <= Maximum_Date
&& Selected_Date >= Minimum_Date,
[Sales ACT],
BLANK ()
)
2Sales Rolling 12 Month ACT (Totals) =
IF (
HASONEFILTER ( 'Calendar'[Date] ),
[2Sales Rolling 12 ACT],
SUMX ( 'Calendar', [2Sales Rolling 12 ACT] )
)
Also please check the pbix as attached.
Hi @Anonymous ,
Please update the measures like this.
2Sales Rolling 12 ACT =
VAR Maximum_Date =
MAX ( 'Rolling Calendar'[Date] )
VAR Minimum_Date =
EDATE(Maximum_Date,-11)
VAR Selected_Date =
MAX ( 'Calendar'[Date] )
RETURN
IF (
Selected_Date <= Maximum_Date
&& Selected_Date >= Minimum_Date,
[Sales ACT],
BLANK ()
)
2Sales Rolling 12 Month ACT (Totals) =
IF (
HASONEFILTER ( 'Calendar'[Date] ),
[2Sales Rolling 12 ACT],
SUMX ( 'Calendar', [2Sales Rolling 12 ACT] )
)
Also please check the pbix as attached.
Hi @Anonymous
Would it help to use
Sales Rolling 12 ACT = VAR Maximum_Date = MAX ( 'Rolling Calendar'[Date] ) VAR Minimum_Date = DATE ( YEAR ( Maximum_Date ) - 1; MONTH ( Maximum_Date ); DAY( Maximum_Date ) ) VAR Selected_Date = MAX ( 'Calendar'[Date] ) RETURN IF ( Selected_Date <= Maximum_Date && Selected_Date > Minimum_Date; [Sales ACT]; BLANK () )
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 |
---|---|
112 | |
96 | |
78 | |
68 | |
55 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |