Precentage difference between the date

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-5c3243d1f9

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.