Forum Discussion

UditJ's avatar
UditJ
Helper III
3 years ago
Solved

Replicating Tableau Calculated Formula

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? 

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.