I have two tables: table 1:
Product LOB
BVPN NS
SD-WAN IS
QUICK START NS
BVPN SMALL OSBU
Table 2:
Product LOB
BVPN NS
SD-WAN IS
QUICK START NS
BVPN SMALL NS
I want to create a custom column that will change the value "OSBU" in LOB column of table1 to NS based on the value in LOB column of table2 and keep other values same. I used the following code but it's not giving me the desired output. Can anyone tell what is wrong?
Column=IF('table1'[LOB]="OSBU",RELATED('table2'[LOB]),'table1'[GOLD_BILLING_PROFILE.Product/Service])
Aucun commentaire:
Enregistrer un commentaire