Tableau to Power BI Migration

[Anonymous]

I am currently working on migrating Tableau Reports to Power BI. I am currently facing problems in converting the Tableau Calculation. Needed help in this.

Required Calculted Column in Power Bi: 

 MPR YEAR CATEGORY GROUP = IF
[MPR Year Category] = '2000' OR
[MPR Year Category] = '2001' OR
[MPR Year Category] = '2002' OR
[MPR Year Category] = '2003' OR
[MPR Year Category] = '2004' OR
[MPR Year Category] = '2005' OR
[MPR Year Category] = '2006' OR
[MPR Year Category] = 'pre-2006' OR
[MPR Year Category] = '2007' OR
[MPR Year Category] = '2008' OR
[MPR Year Category] = '2009' OR
[MPR Year Category] = '2010' OR
[MPR Year Category] = '2011' OR
[MPR Year Category] = '2012' THEN 'Legacy-Pre2013'
ELSEIF
[MPR Year Category] = 'Proposal' OR
[MPR Year Category] = '0' OR
ISNULL([MPR Year Category]) THEN 'WIP'
else [MPR Year Category]
END

[amitchandak]

@Anonymous , Try like

MPR YEAR CATEGORY GROUP = Switch( True() ,
[MPR Year Category] in { "2000" , "2001" , "2002" , "2003" , "2004" , "2005" , "2006" , "pre-2006" , "2007" , "2008", "2009" , "2010", "2011" , "2012", "Legacy-Pre2013" },
[MPR Year Category] in { "Proposal" , "0"},
isblank([MPR Year Category]) , "WIP"
, [MPR Year Category]
)

refer if needed

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56