Forum Discussion

Djaber_TEFFAHI's avatar
Djaber_TEFFAHI
Frequent Visitor
8 years ago

Dax Query

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 :D (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

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    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's avatar
      Djaber_TEFFAHI
      Frequent Visitor
      8 years ago

      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