Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculate Subtotals based on column value in Power Query M

I have been trying to find a solution for this, but I just can't get my head around it.   I want to do a kind of SUMIFS in Power Query Editor using M-Language.     So I have a table like this: ...
Need Help
Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous ,

I would use an if statement to return either of the two different values depending on whether the value of the decimal zero or not.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel