Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Show current and Pervious percentage



I have a requirement in which there was three slicer and i should show current and previous values based on slicer.

For example if week 5 is selected from slicer,it should current and previous(week 4 value )same for quarter and month wise as well.


Current formula=divide(count(Incidentid)>24/Total Incidents in Percentage.

 i want to show for previous as well.




Super User
Super User

@rajkarthik2607 , check if the week rank approach can help you.  All slicer and date related columns hsould come from date table 


new columns in date table
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)
Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
Week Rank RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format


This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))

Last Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))


Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date:

Power BI — Week on Week and WTD



Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors