Replicating Tableau Calculated Formula

[UditJ]

Can anyone help me in replicating the below formula from tableau in power bi :

IF ISNULL ([Data Lag]) THEN 'NO COLOR'
ELSEIF [Secondary Data Source] = 'NielsenDARCampaignMonthly' THEN
IF DATEDIFF('month',[Last Data Date], TODAY()) >=2 AND DATEDIFF('day',DATETRUNC('month',TODAY()),TODAY() ) >= 14 THEN 'RED'
ELSE 'GREEN' END
ELSEIF [Data Lag] >= 3 THEN 'RED'
ELSEIF [Data Lag] = 2 THEN 'YELLOW'
ELSEIF [Data Lag] < 2 THEN 'GREEN'
END

Any suggestions? 

[v-xinruzhu-msft · Accepted solution]

Hi @UditJ 

You can refer to the following calculated column

Column =
SWITCH (
    TRUE (),
    [Data Lag] = BLANK (),
        IF (
            [Secondary Data Source] = "NielsenDARCampaignMonthly",
            IF (
                DATEDIFF ( [Last Data Date], TODAY (), DAY ) >= 2
                    && DATEDIFF ( EOMONTH ( TODAY (), -1 ) + 1, TODAY (), DAY ) >= 14,
                "RED",
                "GREEN"
            ),
            "NO COLOR"
        ),
    [Data Lag] >= 3, "RED",
    [Data Lag] = 2, "YELLOW",
    [Data Lag] < 2, "GREEN"
)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.