I have Country, Year and Total Population Measure in the population Table,
I want to know the difference of Population Year on Year in figures as well as in percentage)
I have tried mention below attempts.
Created the (mention below date year is into the different table where i have connected it with population) the formula doesnt give any error but when
Go to Solution.
SAMEPERIODLASTYEAR requires a column containing dates. Your 'Date'[Year] column does probably not contain date values. Try using 'Date'[Date] (if possible) instead.
View solution in original post
Wow, this worked, thank you Moov
How should i get the difference for each year? @MoOv
I am not sure what you mean. If you drag the measure into the visual, does it not display the correct difference for each year?
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!