Forum Discussion
Code this DAX formula in M
Hello, I would like to code this DAX formula in Power Query M ? What is the solution please ? Lat = var Notif='TASK'[Notification] var Task_Number='TASK'[Task number] var Task_Number_...
Hi Anonymous ,
Please create a custom column.
=
let
a = Table.SelectRows(PreviousStepName,(x)=>x[Notification]=[Notification] and x[Task number]>[Task number]),
b = List.Min(a[Task number]),
c = List.Max(Table.SelectRows(a,(y)=>y[Task number]=b)[Latitude])
in
c
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Thank you very much for your help, it works but it takes a lot of time to load, to you have another solution for large dataset please ?