Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
105 | |
101 | |
81 | |
79 | |
67 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |