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...
Anonymous
Debit =
SWITCH(
TRUE(),
'gbkmut'[transtype] IN {"N", "C", "P", "F"} &&
(
('gbkmut'[transsubtype] NOT IN {"R", "S"} && 'gbkmut'[bdr_hfl] >= 0) ||
('gbkmut'[transsubtype] IN {"R", "S"} && 'gbkmut'[bdr_hfl] < 0)
),
'gbkmut'[bdr_hfl],
BLANK() // Equivalent to NULL
)
Credit =
SWITCH(
TRUE(),
'gbkmut'[transtype] IN {"N", "C", "P", "F"} &&
(
('gbkmut'[transsubtype] NOT IN {"R", "S"} && 'gbkmut'[bdr_hfl] >= 0) ||
('gbkmut'[transsubtype] IN {"R", "S"} && 'gbkmut'[bdr_hfl] < 0)
),
BLANK(), // Equivalent to NULL
-'gbkmut'[bdr_hfl]
)
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn