If tow column values are not equal, then 3rd column values replaced by 0.

[Anonymous]

Dear Expert,

Pleaes provide the solution for the below query:

we have two columns called SCM WareHouse & SAP B1 WareHouse. If these two coluns warehouses are not equal then SCM OnHand values should be replaces by 0 existing value. 

For better understanding please have a look on attached screen shots:
Expecting the colume SCM OnHand column which highlighted with colour in Result table.

Logic: IF(SCM WareHouse <> SAP B1 Warehouse) then SCM OnHand exisiting 315 value should be filled with 0.
for matching WareHouses values should not be changed.

 Thanks,

Sarenn

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create calculated column.

SCM OnHand =
var _flag=ISERROR ( VALUE ('Table'[SAP B1 WareHouse]))
return
IF(
    _flag=FALSE() && FORMAT('Table'[SCM WareHouse],"General Number") = 'Table'[SAP B1 WareHouse],[SAP B1 OnHand],0)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly