Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
My data looks like this. For each district name there is the data of total population for 2017, 2016,2015,2014 and 2013. I want to calculate the % change from the previous year for every district for every year. Please help @Mubashir
try this or a measure (not calculated column):
Growth = VAR __Year = MAX('Table'[Year]) VAR __ThisYearValue = CALCULATE( SUM('Table'[Total]), 'Table'[Year] = __Year) VAR __PreviousYearValue = CALCULATE( SUM('Table'[Total]), 'Table'[Year] = __Year - 1) RETURN DIVIDE(__ThisYearValue-__PreviousYearValue,__PreviousYearValue)
then put the Year and District in the visual you want (don't summarize years) and add the measure
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
48 | |
24 | |
20 | |
14 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |