Forum Discussion
Solved
Divide values based on date
Hello everyone, I'm fairly new to PowerBI and I can't make this measure work. I have two tables: 1 - The first one repeats the names of every city, adding the year in another column. Amount Ci...
The easiest way would be to unpivot your data. Check here for a guide.
https://radacad.com/pivot-and-unpivot-with-power-bi
Once your data is in multiple rows per country, you should be able to used SELECTEDVALUE to find the correct value.
The easiest way would be to unpivot your data. Check here for a guide.
https://radacad.com/pivot-and-unpivot-with-power-bi
Once your data is in multiple rows per country, you should be able to used SELECTEDVALUE to find the correct value.