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 ,
I have a table which contains following columns.
Year
NetRating
Risk Status
Risk Titles
etc
I need to show the NetRating of all the Risk Titles which have
A) Risk Status as dropped in current Year
B) Risk Status as Carried over or New in Previous year
C) Risk Status as Dropped in Current Year
Could anyone help me with a DAX.
Assume that Difference of year can be taken as DATEADD(YearColumn,-1 , Year )
Thanks
Solved! Go to Solution.
Hi @Anonymous ,
You should create a CALENDAR table to work on it. Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Hi @Anonymous ,
You should create a CALENDAR table to work on it. Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |