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.
I tried to write DAX expression in TOM Model to get the rank based on three categories but didn't got solution.
Ex: There are 2 schools and each schools have different year and each year have date.Table contains other columns as well but I need rank on three columns.
Please share any idea.
Solved! Go to Solution.
HI @Tejesh_Gour,
According to your description and snapshot, you want to rank datevalue based on current 'schoolid' and 'yearid' category, right?
If this is a case, you can try to use following calculated column formula:
RANK = COUNTROWS ( FILTER ( ALL ( Table ), Table[SchoolId] = EARLIER ( Table[SchoolId] ) && [YearId] = EARLIER ( Table[YearId] ) && Table[DateValue] < EARLIER ( Table[DateValue] ) ) ) + 1
Regards,
Xiaoxin Sheng
pls share sample data structure of your database , mainly that three column should would availble in data structure.
Thanks.
Hello,
pls tell me the field name on which you want to rank.
Ex. Strength of student in schools, Achievement of schools etc,
so on what basis you want a rank ?
Thanks! I have highlighted in screenshot.
SchoolId, YearID, and DateValue
Hello @Tejesh_Gour,
pls send me the output you want for your data pls just type it in excel and send me that, so i can understand what you exactly want.
I'm looking for RANK field which is in attached screenshot.
HI @Tejesh_Gour,
According to your description and snapshot, you want to rank datevalue based on current 'schoolid' and 'yearid' category, right?
If this is a case, you can try to use following calculated column formula:
RANK = COUNTROWS ( FILTER ( ALL ( Table ), Table[SchoolId] = EARLIER ( Table[SchoolId] ) && [YearId] = EARLIER ( Table[YearId] ) && Table[DateValue] < EARLIER ( Table[DateValue] ) ) ) + 1
Regards,
Xiaoxin Sheng
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 |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |