Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Invesco
Helper V
Helper V

6 MONTH ROLLING SALES SPLIT INTO HALF YEARS

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

Invesco_0-1669046501097.png

Not sure how to do the DAX on this one.

1 REPLY 1
Shaurya
Memorable Member
Memorable Member

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.