Forum Discussion
elflakoconk
Helper II
Helper IISameperiodlastyear only returns total
Hi. There's a lot of similar topics buy nothing exactly with the same issue. This meassure returns the total with blank rows. Ok. I have 1 table with year (date) and population: al...
Hi,
I think your main issue is the years themselves. You have 2010, 2015 and 2020. When you ask for the previous year on the 2020 row power bi looks for data from 2019 which doesn't exist.
Can you share a demo pbix file and can try and help.
bcdobbs
Community Champion
Community ChampionHi,
I think your main issue is the years themselves. You have 2010, 2015 and 2020. When you ask for the previous year on the 2020 row power bi looks for data from 2019 which doesn't exist.
Can you share a demo pbix file and can try and help.
elflakoconkHelper II
Helper IIOuch! shure you're right. I was so envolved in the functions and design thath I was missing out the data.
Thank you for your time and help!