Forum Discussion
Selecting rows with highest value within group using virtual table
Hi, Curetnly I have ID (duplicated) column only (Group column does not matter). Starting from this column I want to create a table as below ID Group Rand_Num Max_Rand_ID 1 A...
I have ID (duplicated) column only (Group column does not matter). Starting from this column I want to
1. Generate a 'Rand_Num' column not adding a Colculated column but as DAX variable because I don’t want to increase the file size
2. Create 'Max_Rand by ID' (which is highest Rand_Num within each ID)
3. Iterate the table and filter only Rand() = Max_Rand_ID
==> so I will get unique ID table with highest [Rand_Num]