Forum Discussion

Raul's avatar
Raul
Icon for Post Patron rankPost 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.

v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

Hi Raul,

 

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

 

 

Thanks,
Xi Jin.

Raul's avatar
Raul
Icon for Post Patron rankPost Patron
8 years ago

Thanks v-xjiin-msft, works correct.