Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

LY YTD Calculation

Hi,   I need assistance with creating a DAX formula for LY YTD values. FYI - I have a period slicer in my model (2 slicers, YEAR and QUARTER).   The problem is, the values in my model have...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Total Sales Amount YTD = TOTALYTD([Total Sales Amount],'Date'[Date])
Total Sales Amount (Last Year) = CALCULATE([Total Sales Amount],SAMEPERIODLASTYEAR('Date'[Date]))

I hope this helps!

Regards,

Lewis