Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Help on Treat As calculation

Hi All,   I am raising this as a new thread my actual problem is solved  which is the below one   https://community.powerbi.com/t5/Desktop/Assign-different-value/m-p/2903454#M997567   Basically...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi amitchandak ,

 

My data is slighthly different since you are using user1,2... substitute is working fine but my data is as below

so I used direct text which is replacing fine

Customer = ADDCOLUMNS(CROSSJOIN(SELECTCOLUMNS( DISTINCT('Table'[Customer]), "User", [Customer] ), DISTINCT('Table'[Customer])), "Disp Customer" , if([Customer] =[User] , [Customer] , "B"))

but since everything is assigned with same value which is of no use can we use index or something similar instead of text "B" so we get the desired o/p. please suggest

Thanks in advance