Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am trying to show accumulative sales figures both current month and same month in last year. But when I tried to use PARALELLPERIOD to get sales figure in last year it always shows the whole month on everyday in last year(see the red line)
Measure MTD LY = TOTALMTD([Net Sales];PARALLELPERIOD('Calendar'[Date];-12;MONTH))
This is not what I want, I want to show the accumulative figure on daily basis in last year like green line in following picture. the
black line is the sales figure until yesterday this month. report is refreshed on daily basis. Thanks!!!
You should add the Previous Year filter within a CALCULATE() function. Please try the following formula:
MTD LY = CALCULATE(TOTALMTD(SUM('Calendar'[Amount]),'Calendar'[Date]),SAMEPERIODLASTYEAR('Calendar'[Date]))
Regards,
hi Simon,
thanks, it works. but SAMEPERIODLASTYEAR only gives you the same period in last year, it is not suitable if it is not a completed month because I want the whole month sales in last year. I tried to fix it by using month flag as a slicer on report. thanks anyway! 🙂
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |