Forum Discussion
Prior Year dax
Hello, i am not sure what i am doing wrong, but my CY and PY results are the same. CY formula used =calculate(sum([Amount]),DATESMTD('Calendar'[Date])) PY formula =calculate(sum([Amount]),DAT...
amitchandak
Super User
Super UserYuliyaMusiyuk , If you take, day, month, year, or any period that should come from date table in visual
Also try this one
calculate(sum([Amount]),datesmtd(DATEADD('Calendar'[Date],-1,YEAR)))
Thank you! i tried that too, it is just not reading it.... I have a slicer for month and year; tried removing it, putting back - same story: my current and prior numbers match 😞