Forum Discussion
Convert DAX to M
Hi, I have a calculated column that I have created using the DAX syntax below. This works as expected but I'd really like to have this column created in power query but I'm really struggling with the...
Hi M_SBS_6 ,
You can try these in Power query-
1. Group By Id (Choose Advanced)
2. 1st consider all rows
3. In 2nd grouping, add min Sub date
This will give you all the rows with along with sub date and its corresponding Earliest Sub date.
Hope this helps!
If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.