Hello. Create this formula for powerpivot. Can anyone tell me what is wrong with it? Thanks?
=if([Channel]= "DIRECT TO CONSUMER","DTC", if([Channel]="DTC - RENEWAL", "DTC Renewal",if([Channel]= "Portfolio Management", "PM",if([Channel]="PORTFOLIO MANAGEMENT - RENEWAL", "PM Renewal", if([Channel]= "Real Estate", "Real Estate", "RE Renewal"))
Bookmarks