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 there
I've got a table with 3 columns "Company", "Month" and "Rating":
Now I'd like to get a new column (or measure) to get the "Rating" of the previous available month.
If there isn't a value for an earlier month respectively it's the first entry (like Company A / Month 1), the value 0 should be displayed.
My final goal is to have two slicers, one for "Company" and one for "Month" and two card visuals with the information about the "current" rating and the previous rating:
How can I solve this by using DAX?
Thank you in advance for your help!
Best regards,
Tom
Solved! Go to Solution.
@PowerBI_Explore Create a Index Column starts with 1
and create column with this DAX:
@PowerBI_Explore Create a Index Column starts with 1
and create column with this DAX:
Works perfectly like expected, appreciate your help - thank you very much!
Only need to figure out, how I should handle the first entry / record of every company correctly, so that it will display no value instead of the last value of the previous company. I think I should be able to solve this with the same logic and an additional check, if the company is the same then the one with index-1.
Best regards
Dominique
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |