Yesterday and Today Calculation

[Dan84980]

Hi I'm pretty new to Power BI and having one clarification

I have data as Year,Month,Week,Date in table and created slicers to filter the data in power BI , I need to create 2 filter Yesterday/Today , If user click on Today or Yesterday data should display , I'm aware that user can select year then Month,week,day but i'm trying to avoid as many as user clicks, I want user to get data straight away if he/she clicks on slicer(Yest/today)

Thank you in advance, if possible please share documents  for learning power BI 🙂

[DoubleJ]

You could add 2 calculated columns and use these as slicers:

IsToday = IF(Table1[Date] = TODAY(),TRUE(),FALSE())

IsYesterday = IF(DATEADD(Table1[Date],1,DAY) = TODAY(),TRUE(),FALSE())

Hope this helps

JJ

[Dan84980]

Thanks for response, it did works!, but i'm looking something different than this!, Please see below screen shot for reference

Can we get  Mutli circle progras  wheel in power BI, Thanks for your help!, Much appreciated

[DoubleJ]

Ok, so you can create a custom column:

Slicer =IF(DATEADD(Table1[Date],1;DAY) = TODAY(),"Yesterday",IF(Table1[Date] = TODAY(),"Today","Before Yesterday"))

An then use this as slicer:

Is this what you are looking for?

[Irussaa]

how can I made slicer like this?

I mean, how to customize the table data and get that slicer as the result?

---

@DoubleJ wrote:

Ok, so you can create a custom column:

Slicer =IF(DATEADD(Table1[Date],1;DAY) = TODAY(),"Yesterday",IF(Table1[Date] = TODAY(),"Today","Before Yesterday"))

An then use this as slicer:

Is this what you are looking for?

---

---

[Dan84980]

Excellent it works!, thanks for help!, is it possible to hide before yesterday in slicer?, i need only today and yesterday

Thanks for your help!

[Dan84980]

I haven't got any answer yet!

[DoubleJ]

I'm afraid this is not possible

[SergeiStPete]

Hi

You may use this https://blog.crossjoin.co.uk/2016/05/30/creating-current-day-week-month-and-year-reports-in-power-bi... idea