Precentage difference between the date

[Fidzi8]

Hi,
I need advice. 

I have table with this columns

I want to create percenatge difference between the date

For example: from 3 325Kč to 3 500Kč = 5,2%

 

Thank you
Ondřej

[amitchandak · Accepted solution]

@Fidzi8 , Assume you are using a date table for slicer,

Try measure like

Measure =
VAR _min = MINX(allselected(Dates) ,Dates[Date])
VAR _max = MAXX(allselected(Dates) ,Dates[Date])
return
calculate(sum(Table[cost]), filter(Dates, Dates[Date] =_max)) -calculate(sum(Table[cost]), filter(Dates, Dates[Date] =_min))

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...

[v-angzheng-msft · Accepted solution]

Hi, @Fidzi8 

Try this:

Measure =
VAR _min =
    MINX( ALLSELECTED( Dates ), Dates[Date] )
VAR _max =
    MAXX( ALLSELECTED( Dates ), Dates[Date] )
VAR _a =
    CALCULATE(
        SUM( Table[cost] ),
        FILTER( ALL( 'Dates' ), Dates[Date] = _min )
    )
VAR _b =
    CALCULATE(
        SUM( Table[cost] ),
        FILTER( ALL( 'Dates' ), Dates[Date] = _max )
    )
RETURN
    DIVIDE( b - a, b )

Or, please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate measure.

Best Regards,
Community Support Team _ Zeon Zheng

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

[amitchandak · Accepted solution]

@Fidzi8 , Assume you are using a date table for slicer,

Try measure like

Measure =
VAR _min = MINX(allselected(Dates) ,Dates[Date])
VAR _max = MAXX(allselected(Dates) ,Dates[Date])
return
calculate(sum(Table[cost]), filter(Dates, Dates[Date] =_max)) -calculate(sum(Table[cost]), filter(Dates, Dates[Date] =_min))

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...

[Fidzi8]

Hi @amitchandak,
thank you for your help.

The formula doesn´t work properly and I don´t know where the error might be.

Thank you

Ondřej