Forum Discussion

rpinxt's avatar
rpinxt
Solution Sage
3 years ago
Solved

How would this DAX code look in M?

So I have this DAX code to add a column: MaxLog = MAXX( FILTER('1UAL_Data','1UAL_Data'[Delivery] = EARLIER( '1UAL_Data'[Delivery] )),'1UAL_Data'[LoggedOnDate_Local])   Now I want to add this colu...
Need Help
  • goncalogeraldes's avatar
    goncalogeraldes
    3 years ago

    Hi rpinxt ! Create a duplicate of the '1UAL_Data' table and add the following step in the new query. Your M code may look something like:

     

    = Table.Group(Previous_Step_Name, {"Delivery"}, {{"LoggedOnDate_Local", each List.Max([LoggedOnDate_Local]), type number}})

     

    This code can be achieved with a "Group by" on Power Query. You can later merge this new query in the original table and expand the newly computed column!

     

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
    Thanks!

    You can also check out my LinkedIn!

    Best regards,
    Gonçalo Geraldes

rpinxt's avatar
rpinxt
Solution Sage
3 years ago

Ah ok thanks for this info.

 

Unfortunately I have Pro license.

So then I will have to do it in DAX.

Or do you mean with Pro you can do it in a Dataset but not in a Dataflow?

goncalogeraldes's avatar
goncalogeraldes
Super User
3 years ago

You can do it in a dataset with Pro license but not with a dataflow 🙂