Forum Discussion
Spotto
Helper IV
Helper IVSpecify annual average measure
hello guys, I would like to create a measure that could bring the annual average, but I would like to specify the period that was from June to May of the following year of all years.
I left a test file attached.
I appreciate the help.
https://drive.google.com/file/d/1e2Kknu2ZlsMiETIFX1BBpn-324IHzMo-/view?usp=sharing
2 Replies
- amitchandak
Super User
Spotto , Assuming 5/31 is fixed, you have used a measure like this
YTD Sales = CALCULATE(AvergaeX(Values('Date'[Month Year]), CALCULATE(SUM(Sales[Sales Amount]))),DATESYTD('Date'[Date],"5/31"))
Spottothanks for your time but i tried your solution and did not work, I left the file in the post could if you want to test.
