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.
Hi guys,
I have a table with multiple rows, "years" as columns, and "revenue" as value. What I want is to create a measure which calculates the following:
Revenue (year in column) / Revenue (Year in previous column)
This way i get a year to year revenue growth.
I can only manage to find a way to create a measure which creates the value of the previous year, but not the growth of the previous year compared to that previous year.
For example I need the measure to calculate 2019/2018, but also 2018/2017, and 2017/2016.
Quick measures wont work.
Solved! Go to Solution.
Hi @v-frfei-msft,
I can post a screenshot of the table how I got him after using my solution.
Hopefully this will help someone else in the future.
Kind regards,
Adi
Hi @AdiKujan,
Could you please share your sample data and excepted result to me, if you don't have confidential data? Please upload your file to One Drive and share the link here.
Regards,
Frank
Hi @v-frfei-msft,
I can post a screenshot of the table how I got him after using my solution.
Hopefully this will help someone else in the future.
Kind regards,
Adi
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |