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.
I am not able to calculate growth% based on hierarchy dimension
My formula is (CY/PY)*100 WHERE CY DENOTES CURRENT YEAR AND PY DENOTES PREVIOUS YEAR
THIS FORMULA SHOULD WORK ON STATE, REGION, CITY WISE
AS CURRENTLY IT SHOWS INCORRECT VALUE.
Also the values are not getting aggregate as per the dimensions.
Solved! Go to Solution.
Solution for your problem
create measure not column
1. Measure = sum('2016-2017') / sum('2015-2016')
Once create the measure . just click on the measure and go to the modelling ribbon
do click the % symbol
2. Yes we have the function to compare previous year like PREVIOUSYEAR for that u want one date column .
anyhow check the previous functions in DAX that will help u dude
Hi @JPotwade,
Could you post your table structures, and some sample data with your expected result in this case?
Regards
Thanks for your reply.
Table Structure
I want to cacluate growth% i.e. (2016-17 /2015-16)*100 based on state, region city.
Now growth% is getting calculated based on each row level and if i display data statewise growth% then it sum the value.
Please suggest any solution as i am not able to display data based on hierarchy level.
Also i want to know is there any prebuild function to calcualte the percentage variation or growth as compare to previous year or month or week. Note: I don't want to write DAX query it should be prebuilt function.
Solution for your problem
create measure not column
1. Measure = sum('2016-2017') / sum('2015-2016')
Once create the measure . just click on the measure and go to the modelling ribbon
do click the % symbol
2. Yes we have the function to compare previous year like PREVIOUSYEAR for that u want one date column .
anyhow check the previous functions in DAX that will help u dude
Awesome dude.
I was thinking how come it was not possible in PowerBI and easily available in other tools.
Thanks for your help.
Also Please let me know Percentage Variation formula. It will help me to give raw data to PowerBI
we can do anything in DAX dude. Learn DAX it will helpfull cheers .
we will meet in next issue .
can u please share ur formula , and sample data .
i will help u dude
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |