I have to show how Sales changes over the year, but the same month last year and compare. So lets say last month dec18 was 21, then this should be compared with the value for dec19. Therefore, I used MTD. If somebody just can confirm if this is right?
Another question is that the KPI Card has to show the total yoy change for that specific period, so depends on where I put the date slicer in. If date slicer is on 4/18-3/19, then the KPI card should display the total of yoy change for 4/18-3/19. Even if i put it in the matrix, the grand total just shows me the value of last month but doesnt count the total of yoy change. I know that KPI card just display current value , but how can the measure look like so I can see the total of yoy change with the KPI Card. I have no idea how to create that measure. I just simulated the problem in the file but for some reason I cant attach the file. So I attached the file here :
thank you soo much for your answer and for your help!!!! I really appreciate it!! I just have a question, in order to understand your measure. Can you explain this one ? What does this one exactly do? Having Sameperiodlastyear and dateadd in one measure.