Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Transform Excel Command to DAX or M Language

Hi,   I created this command but need help to transform it to Dax or M Language.   Thanks...tksnota...   (CASE WHEN transtype IN('N','C','P','F') AND (((gbkmut.transsubtype NOT IN ('R','S') A...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi,

 

I have these errors.

 

Thanks...tksnota...

 

 

_AAndrade's avatar
_AAndrade
Resident Rockstar
1 year ago

Hi Anonymous,

Could you share a pbix file with same data so I could take a look?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

     

    Hi,

     

    How about we change the Dax wherein any GL Code that starts with "7" and "4" will be extracted to Calculated Column called Debit and anything that starts with "8" will be credit (as shown)?

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi 

     

    Thanks for the pbix.

     

    I tried your DAX but my problem is the system won't show the column only the sum as shown from the black box.

     

    Anything I need to do so I can get the correct columns?

     

    Thanks...tksnota...

     

     

  • _AAndrade's avatar
    _AAndrade
    Resident Rockstar
    1 year ago

    Hi,

    What column you're using on your Sum measure? Should be that column, I guess...
    I can help you more than this with the information than I have... sorry