Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
SaiKumar
Frequent Visitor

Tableau to Power Bi

Hi All,

 

Can someone help me to convert tableau calculation to power bi dax calculation

 

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

2 REPLIES 2
Mohammad_Refaei
Solution Specialist
Solution Specialist

Try this:

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", BLANK () }, "WIP",
    [MPR Year Category]
)

MPR Year Category  is direct column

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors