Forum Discussion

Wedding55's avatar
Wedding55
Icon for Helper II rankHelper 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:)

BITomS's avatar
BITomS
Icon for Solution Supplier rankSolution Supplier
2 years ago

Hi Wedding55 ,

 

It sounds like the Group By function could help here (available in the Transform tab)?

 

Group By Date_per_month and use the MAX aggregation?