Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
sat125
Frequent Visitor

differentiate second filtered value from first filtered value

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

 

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@sat125 

 

Here is a similar case for your reference.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@sat125 

 

Here is a similar case for your reference.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super User

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!