Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'd like to create a measure, that show the latest two attributes of the column Type by Date.
So in this example for Brand A, the measure should only show Type = "Red" on April and May. For Brand B it should show Blue in April and Red in May. The attributes can be concatenated or displayed in each row.
Thank you for your help.
Solved! Go to Solution.
@thhmez7 , if you do not want that based on slicer value, You can use column rank and use that as filter
rank = rankx(filter(Table, [Brand] = earlier([Brand]) ) , [Date],,desc,dense)
filter for <= 2 in a measure of visual level filter
@thhmez7 , if you do not want that based on slicer value, You can use column rank and use that as filter
rank = rankx(filter(Table, [Brand] = earlier([Brand]) ) , [Date],,desc,dense)
filter for <= 2 in a measure of visual level filter
Thank you.
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |