Forum Discussion

Wedding55's avatar
Wedding55
Helper II
2 years ago
Solved

Filtering Max Date with AllEXECPT in M Language

Hello everyone, I have the following Dax formula to create a new column in the Power BI Report.. However, I would like to create this step in the Query Editor. But im not sure how to do this. I crea...
Need Help
  • Wedding55's avatar
    Wedding55
    2 years ago

    Hey, thanks for your answer. I solved it with ja group by function and joined the data later:)

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

Thanks for the solution BITomS  provided, and i want to offer some more information for user to refet to.

hello Wedding55  , you can create a custom column and try the following code.

let a=[Date_per_month]
in List.Max(Table.SelectRows(#"Changed Type2",each[Date_per_month]=a)[LastDate])

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.