Forum Discussion
index/rank/generate for groups with dates
Hi,
Please check the below picture and the attached pbix file.
Super UserHi,
Please check the below picture and the attached pbix file.
Jihwan_Kim, This solution works wonderfully as a calculated column. But what about as a transform step in Power Query Editor?
The reason I need it in Power M Query, is becuase I want to be able to perform a transformation on a seperate table that uses a merg queries to bring the index over to a new table of related data. If the index column only exisists as a calculated column, it wont be avalible in power query edidtor for transformations.
Oh, I am sorry Jihwan_Kim , I just noticed you included the PBIX file with the transform solutions on the sample data.
Let me implement that now and see if it completes the solution.YES! Your code Jihwan_Kim for power M Query solved this exactly as expected.
Thank you!