Forum Discussion

Raul's avatar
Raul
Post Patron
8 years ago
Solved

DAX Measure to M language

Hello,

I need to convert this Measure to a new column into Query editor in M language:

TempFACT = CALCULATE(SUM(Task[Amount]);Task[Type]="A")

Is it possible?

Thank you!!

Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Hi Raul,

     

    You can simply achieve it with Group By option in Edit Queries. Something like:

     

     

    Thanks,
    Xi Jin.

4 Replies

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Solution Sage
    8 years ago

    Hi Raul,

     

    You can simply achieve it with Group By option in Edit Queries. Something like:

     

     

    Thanks,
    Xi Jin.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Why can't you just do it in a DAX calculated column?

     

    Like:

     

    TempFACT = SUMX(FILTER(ALL(Task),[Task]="A"),[Amount])
    • Raul's avatar
      Raul
      Post Patron
      8 years ago

      Hi Greg_Deckler

      Because in the report page where there are this measure are a lot of them and I want to traspas it into the table in a column in the query because when I filter the report it's very slow.