differentiate second filtered value from first filtered value

[sat125]

Hi ,

  I want to differentiate first filtered value  from second filtered value, how can i do this?

For example when i select 24.12.2019 as filter it has a card as 3,57

when i select 27.12.2019 it has a value as 3,62

i want to subtract tem from each other, as i select any filter value...

thanks for help

[v-chuncz-msft · Accepted solution]

@sat125 

Here is a similar case for your reference.

https://community.powerbi.com/t5/Desktop/Plot-difference-between-two-rows-based-on-slicer-selection/...

[amitchandak]

Try the formula below

To get the best of the time intelligences. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s.

Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions

Change % = 
Var _max= (maxx('Date''Date'[Date]))
Var _min= (minx('Date''Date'[Date]))


Var _last= CALCULATE(sum(Sales[Sales Amount]),(Sales[Sales Date])=_min)
Var   _This =CALCULATE(sum(Sales[Sales Amount]),(Sales[Sales Date])=_max)
return
(_This-_last)/_last*100

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601