I would like to find YTD sales amount my measure is
Go to Solution.
Finally, i found the solution
Sales YTD = TOTALYTD(sum(sales[salesamount),'DateTable'[Date],"09/30")
View solution in original post
@ranga_88 You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
@Greg_Deckler sorry i could't find my solution
this is my calender table
i want Cummulative sum October to September any Luck?
Fisical year started at Oct to Sep
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!