Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I created NBA Playoff tables (Eastern and Western conference) and I would like to pick (first 8 of 15) the teams like that
1 place and 8 place
2 and 7
3 and 6
4 and 5
* this table change every day during the legue and I would like to pick the team name regardless who is in the 1st raw
I've tried ranking but it didn't work and I coudn't create a row_num like TSQL with DAX any idea
Thanks
Oded DrorAs you can see today is Boston Vs Miami but tomorrow it could be different teams
Solved! Go to Solution.
@odeddror , try the newly released index function, with help of that you should be able to get data on a particular number , you can get 1 and 8 and show them together
Dax Function Offset, Window, Index: https://youtu.be/KhkCALjHylE
@odeddror , try the newly released index function, with help of that you should be able to get data on a particular number , you can get 1 and 8 and show them together
Dax Function Offset, Window, Index: https://youtu.be/KhkCALjHylE
Amit,
I follow your video and i did
P.S i added an Index Column in Power Query
Amit,
In your video you are using numbers and dates but in my case it only dynamic names that need to extract
Just show me the name of the 5th raw regardless who is there
Thanks,
Oded Dror
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |