Calculated column

[Anonymous]

Hi all,

I have three columns in my database ("FO Country", "FP Country", "Mkt Country").  I want to make another calucated column ("IDops") based on variation of three column values as following rule:

when

Indonesia=FO Country=FP Country=Mkt Country>"Local FF&P"

Indonesia=FO Country (not equal to FP & Mkt country)>"Bulk Export"

Indonesia=FP Country (not equal to FO & Mkt Country)>"FG Export"

Indonesia= FP Country= Mkt Country(not equal to FO country)> "Local FP"

[Anonymous]

Hi @Anonymous  ,

Please share sample data or share your .pbix file.

Thanks,
Robin