How to calculate "Difference % From Previous date"

[MoayadGharaibeh]

Hi Community,

I was using Excel Dashboards and want to move it to PowerBi. One feature in (excel Pivot Chart) i was using frequently and can't find it in PowerBI is (Show Values As > % Difference From.. > Base Field: Date/Base Item: (Previous)):

I need the data to be shown in the Dashboard as per the following lines (secondary axis):

How to do it in PowerBI, knowing that i'm a beginner.

Thanks

[MoayadGharaibeh]

Thank you @v-jingzhang 

That helped alot and now its working but:

if the previous day was Friday, i have no data for Friday, then Saturday's difference are always -100% (Check below 5/7/2022:  

in this case i need it to calculate the difference between Sat and Thu, is there an easy way to do so?

and always the 1st selected date are 0%, which used to be blank in excel pivot chart, check below same chart in excel:

Thanks again.

Moayad

[v-jingzhang]

Hi @MoayadGharaibeh 

You are welcome. You can refer to this blog about how to sort weekday names. By default, it is sorted alphabetically. So the idea is to add a number type "weekday number" column, then sort "weekday name" column by the "weekday number" column. 

Jing

[MoayadGharaibeh]

Hi @v-jingzhang 

Thank you i figured out how and edited my message. Can you please check my latest edited reply?

Appreciated.

Moayad

[v-jingzhang]

Hi @MoayadGharaibeh 

Will the first date always be the month start date? If so, you can try below measure.

Price % difference from Yesterday =
VAR _CURRENT_DATE = MAX ( 'Table'[Date] )
VAR _CURRENT_WEEKDAY = WEEKDAY ( _CURRENT_DATE, 2 )
VAR _CURRENT_DAY = DAY ( _CURRENT_DATE )
VAR _BASE_DATE = IF ( _CURRENT_WEEKDAY = 6, _CURRENT_DATE - 2, _CURRENT_DATE - 1 )
VAR __BASELINE_VALUE =
    IF (
        _CURRENT_DAY = 1,
        BLANK (),
        CALCULATE (
            SUM ( 'Table'[Price] ),
            ALL ( 'Table'[Date] ),
            'Table'[Date] = _BASE_DATE
        )
    )
VAR __VALUE_TO_COMPARE = SUM ( 'Table'[Price] )
RETURN
    IF (
        NOT ISBLANK ( __VALUE_TO_COMPARE ),
        DIVIDE ( __VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE )
    )

Jing

[v-jingzhang · Accepted solution]

Hi @MoayadGharaibeh 

In Power BI, you can create a measure to get the daily difference %. I create a sample for your reference. 

Additionally, there are quick measures you can use. But I don't find a quick measure that can calculate the expected result directly, so I modify the code of one quick measure to get the above measure. Pbix file is attached at bottom.  

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.