Forum Discussion
YoY for calculation till selected month
Greetings everyone ! Here's the issue that I am facing. I have two tables, one for date and other for sales. Slicer is maintain for Month field; data need to be presented as below - 1. Yea...
What you are suggesting does not work when there's a slicer on Month in the report. Kindly re-read the query, If I select a month in slicer then YTD should SUM up values only till selected month for each FY i.e. if I select March it should show Jan to March sale for FY21, FY20, FY19 and so on.
I have applied below formula for calculating YTD and its working fine and for YoY below formula is used which is not working -
MAX_MONTH = MAX('Date'[MonthNo])
Sales YTD =
Var A = [MAX_MONTH]
Return CALCULATE([SALES], ALL('Month'), 'Date'[MonthNo] <= A)
Sales YTD LY = CALCULATE([Sales YTD], SAMEPERIODLASTYEAR('Date'[Date]))
Sales YTD YoY = DIVIDE(Sales YTD-Sales YTD LY, Sales YTD LY, 0)
Kindly suggest if you know how can I correct YoY formula.
manikumar34
Solution Sage
Solution SageMAX_MONTH = MAX('Date'[MonthNo])
Sales YTD =
Var A = [MAX_MONTH]
Return CALCULATE([SALES], ALL('Month'), 'Date'[MonthNo] <= A)
Sales YTD LY = CALCULATE([SALES], ALL('Month'), 'Date'[MonthNo] <= A && 'Date'[Year]=Year(Max(Date[Date]))
Sales YTD YoY = DIVIDE(Sales YTD-Sales YTD LY, Sales YTD LY, 0)
Just alter your LY to above DAX