Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Difference between YTD and Total sales

Hello all,
Iam trying to check the Year over Year Growth for YTD 2019.

I have created following measures

Totalsales$ = SUM(SellThrough[RetailDollars])
TotalSales$LY = CALCULATE([Totalsales$],SAMEPERIODLASTYEAR('Calendar'[Date]))
YTD Sales$ = TOTALYTD('Key Measures'[Totalsales$],'Calendar'[Date])
YTD Sales$ LY = CALCULATE([YTD Sales$],SAMEPERIODLASTYEAR('Calendar'[Date]))
 
But I dont see any difference in the visualization numbers 
 
 what Am I doing wrong. Please help.
 
Thanks
 
Need Help
  • dax's avatar
    dax
    7 years ago

    Hi RuksanaBegum,

    You said the results are same for these two measures, because they are calculate Year result and they year results on 2019 are same. You could compare it based on month, then you will get the difference between these measures

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi RuksanaBegum,

    You said the results are same for these two measures, because they are calculate Year result and they year results on 2019 are same. You could compare it based on month, then you will get the difference between these measures

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.