Forum Discussion

Dan84980's avatar
Dan84980
Regular Visitor
9 years ago

Yesterday and Today Calculation

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/To...
General Comment
DoubleJ's avatar
DoubleJ
Solution Supplier
9 years ago

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's avatar
Dan84980
Regular Visitor
9 years ago

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!