Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hello Muhammad,
SAMEPERIODLASTYEAR requires a column containing dates. Your 'Date'[Year] column does probably not contain date values. Try using 'Date'[Date] (if possible) instead.
Regards,
Moritz
Hello Muhammad,
SAMEPERIODLASTYEAR requires a column containing dates. Your 'Date'[Year] column does probably not contain date values. Try using 'Date'[Date] (if possible) instead.
Regards,
Moritz
How should i get the difference for each year? @Anonymous
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?
Wow, this worked, thank you Moov
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |