Forum Discussion
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:
also tryed with this:
I've created my meassure:
And this is what I get:
Also I've tryed this:
Anyone has an idea about what's happening?
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.
2 Replies
- bcdobbs
Community Champion
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.
elflakoconkOuch! 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!