6 MONTH ROLLING SALES SPLIT INTO HALF YEARS

[Invesco]

Hi Experts

I need a single measure that works out 6 monthly cumulative sales Period JAN - JUN and JULY - DEC this has to be dynamic based on the year selected...

see image below

Not sure how to do the DAX on this one.

[Shaurya]

Hi @Invesco,

Here's a video by @amitchandak that should solve your problem.

https://www.youtube.com/watch?v=fkm3Xvjcpl0

Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI