March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi, I have this measure for 12 months rolling sales:
I suggest to look at the endofmonth function, so go one month back and then endofmonth as your boundary.
https://docs.microsoft.com/nl-nl/dax/endofmonth-function-dax
Hope it helps. Kind regards, Steve.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
hi havnt tried but maybe something like this.
might get funky if your calendar is not complete?
var minDate=EOMONTH(MAX('Calendar'[Date]),-13)
var fromDate=DATE(YEAR(minDate),MONTH(minDate),1)
var toDate=EOMONTH(MAX('Calendar'[Date]),-1)
return
CALCULATE(SUM(Table2[value]),
FILTER(ALL('Calendar'),
'Calendar'[Date]>=fromDate &&
'Calendar'[Date]<=toDate
)
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
62 | |
27 | |
25 | |
22 | |
16 |