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 DATEDIF...
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.

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.