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.
Dear All,
I would need your help as I do not manage by myself to solve my problem
I have simple measure
Volume Growth rate = ((calculate((calculate(sum('Tint Sales'[Volume]);'Tint Sales'[CATEGORY_ID] >= 1;'Tint Sales'[CATEGORY_ID]<= 4;'Year'[Year]=2017)+calculate(sum('Tint Sales'[Volume]);'Tint Sales'[CATEGORY_ID] = 6));'Year'[Year]=2017))/(calculate((calculate(sum('Tint Sales'[Volume]);'Tint Sales'[CATEGORY_ID] >= 1;'Tint Sales'[CATEGORY_ID]<= 4;'Year'[Year]=2016)+calculate(sum('Tint Sales'[Volume]);'Tint Sales'[CATEGORY_ID] = 6));'Year'[Year]=2016)))-1
In this measure the years are fix. But I would like to change it to variable, if I would choose the in the year filter 2017 in the first part of the measure should be stay 2017 and in the second part 2016. The same if I choose in the filter 2016, in the first part should stay 2016 and in the second part should stay 2015.
I would really appreciate if somebody could help me
Thank you in advance
Feri
Solved! Go to Solution.
Assuming that you are using a slicer with year column
2 measures
Year=Values(Year[Year])
Year-1=Values(Year[Year])-1
or you can replace it in your measure
Assuming that you are using a slicer with year column
2 measures
Year=Values(Year[Year])
Year-1=Values(Year[Year])-1
or you can replace it in your measure
Hi @viferenc,
I am very gald you have resloved your issue, please mark the right reply as answer. So that other people having similar problems will find workaround easily. Thanks for understanding.
Best Regards,
Angelia
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |