Forum Discussion

Vosina's avatar
Vosina
Frequent Visitor
6 years ago

%Change YoY (problem wth calculation)

Hi everyone,  in spite there ale quite a lot of videos and descriptions, I have not been able to get to the result I desire with comparing date across years. I have 1 data table with multiple sales ...
Vosina's avatar
Vosina
Frequent Visitor
6 years ago
Greg_Deckler wrote:

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

Thank you Greg.  Gave me some time to figure it out but I managed to enter the Dax you suggest. I got somewhere with the ThisYear formula but the LastYear gives me no values, thus %change does not work either. Would you suggest what I am doing wrong?
1. I have got separate Date table (Kalendar_Lookup) with all dates available in the calendar and calucalted columns with Year and Month. 
2. My data table includes Date (1st day of the month) + Value, there are multiple rows with the same date for multiple Sales reps. (normalized)
Another problem I see here is, that I will not recieve %Change 2017/2018 by this formula

Thank you so much

M.