Forum Discussion
Switch Function based on Different column Reference
Hi All,
Hope you're ll doing good.
Just wanted to check if i can modify the below formula to switch for the differenct columns in differnt tables.
Currently its suming only for the Account name. I have differnt columns like. ServiceLine,Sector,MarketSegment.
Advisory SLI = VAR AdvSLI= IF([Advisory %]>0.1,1,0)
return
IF(HASONEVALUE(SLI[AccountName]),
AdvSLI,
SUMX(VALUES(SLI[AccountName]),AdvSLI))
Regards,
Ranjan
