Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |