Forum Discussion
differentiate second filtered value from first filtered value
- 6 years ago
Here is a similar case for your reference.
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-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