Dax Query

[Djaber_TEFFAHI]

Hello everyone,

I'm beginner in DAX (Firsts operations) :P, i need your Help to undertand SQX queries. in the picture attached to my message you will find the structure of my excel file 😄 (very simple). so what i need is to get the date of last operation performed by a customer 

Hoping you help me. 🙂

Best regards

Djaber

[Greg_Deckler]

Not sure if you want this in Power Query or DAX. Confusing. But in DAX, all you would need is a measure like:

LastOperation = MAX([Date_Operation])

[Djaber_TEFFAHI]

Hello, Thank you for your response max(column) gived me the max of all the column (one value for all the column) i look for max date for each client but i don't know how i do it 😞

Best regards