Forum Discussion

rnola16's avatar
rnola16
Advocate II
1 year ago
Solved

Sum on Case Statement on a column

I'm trying to use this SQL statement in DAX func.   =Sum( CASE when tablename.colname in ('a','b') then -1                       when tablename.colname in ('c','d') then 0                       w...
Need Help
  • kushanNa's avatar
    kushanNa
    1 year ago

    Works for me 

     

    maybe you are trying to use DAX code in M (Power Query) then it will throw an error on 'in' ? if that's the case then DAX functions cannot be used in M query 

     

rnola16's avatar
rnola16
Advocate II
1 year ago

Thank you, that worked. The mistake I did, i tried creating a new column in the power query and didnt work, instead created a new measure on the report page.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi rnola16 ,

     

    If the problem has been solved, please accept as solution the replies you find helpful.

     

     

    Best regards,

    Mengmeng Li