lundi 10 février 2020

Syntax for using RELATED() function under IF Condition in POWER BI

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