Forum Discussion
Solved
Calculated column with IF...Else statement
Hi I have the following tables; only mentioning relevant columns here Merchants with columns CompanyID MerchantName AllTransactions PaymentIntentId CompanyID Fees BrandName IS_Premium (...
Hmm,
this gets very theoretical without actual tables, but you can include in the CONCATENATE formular the LOOKUPVALUE, such as
"New Column" = CONCATENATE ( LOOKUPVALUE(...), ChargeID , BrandID , Fee_Type (domestic/international), Is_Premium)
not quite sure if I am loosing it here 😄
hashtag_pete
Hey,
in DAX it would be "New Column" = CONCATENATE ( ChargeID , BrandID , Fee_Type (domestic/international), Is_Premium)
That would work regardless of the type integer, ...
Does that help? If so, please
- mark this post as a solution
- give kudos
Thanks hashtag_pete
