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
_AAndrade's avatar
_AAndrade
Resident Rockstar
1 year ago

Please try this one

CalculatedTable = 
ADDCOLUMNS(
    'OriginalTable', // Replace 'OriginalTable' with the name of your table
    "Debit", 
    IF(
        CONTAINSROW({ "N", "C", "P", "F" }, [transtype]) &&
        (
            (NOT CONTAINSROW({ "R", "S" }, [transsubtype]) && [bdr_hfl] >= 0) ||
            (CONTAINSROW({ "R", "S" }, [transsubtype]) && [bdr_hfl] < 0)
        ),
        [bdr_hfl],
        BLANK()
    ),
    "Credit", 
    IF(
        CONTAINSROW({ "N", "C", "P", "F" }, [transtype]) &&
        (
            (NOT CONTAINSROW({ "R", "S" }, [transsubtype]) && [bdr_hfl] >= 0) ||
            (CONTAINSROW({ "R", "S" }, [transsubtype]) && [bdr_hfl] < 0)
        ),
        BLANK(),
        -[bdr_hfl]
    )
)
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)?