How to find 20% increase and 20% decrease in yesterdays and day before yesterdays date

[arvindyadav]

Hi Team,

How to find a 20% increase and a 20% decrease in yesterdays and day before yesterdays data In Power BI desktop.

If 20% Increase then displays any text or color and vice-versa.

Thanks,

Arvind

[v-yuta-msft · Accepted solution]

@arvindyadav ,

You can create a measure like pattern below and drag the measure to the card visual:

Result =
VAR yesterdays_value =
    CALCULATE (
        MAX ( Table[Value] ),
        FILTER ( Table, Table[Value] = TODAY () - 1 )
    )
VAR day_before_yesterday =
    CALCULATE (
        MAX ( Table[Value] ),
        FILTER ( Table, Table[Value] = TODAY () - 2 )
    )
RETURN
    IF (
        yesterdays_value - day_before_yesterday / day_before_yesterday > 0.2,
        "Text",
        BLANK ()
    )

Community Support Team _ Jimmy Tao

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

[rocky09]

Check this Article.

Link