Forum Discussion
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
Here is a similar case for your reference.
2 Replies
- v-chuncz-msftCommunity Support
Here is a similar case for your reference.
- amitchandakSuper 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-functionsChange % = 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*100Appreciate 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-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601