Forum Discussion
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...
Hi Anonymous,
Could you share a pbix file with same data so I could take a look?
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,
I'm attaching a pbix file with a quick example. See if this could help you.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...
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