Forum Discussion
If Statement Working With Two Seperate Database Tables
Hello Everyone, I have an request that has been causing me some trouble on how to resolve. I have a need for a new column to be created which uses an If or Case statement where possible. ...
Maverick_BI
You can use the following DAX function:
$Column Customer Ordered = IF(
'SYSADM ORDER'[AH_IDENT] = 'SYSADM CUSTOMER'[ID] &&
'SYSADM CUSTOMER'[ID] <> "0" ||
NOT 'SYSADM CUSTOMER'[LOCKED] IN "1","3"
,"Order","No Order"
)Let me know if this didn't help.
Hello rajulshah,
Thank you for the quick response unfortunately the same message appeared as what I am trying to resolve as shown below.
Maverick_BI Are you creating a new measure or new column?
rajulshahI was originally attempting to do this as a new column, however if I need to do it as a measure then I have no concerns in doing it this way.
