Forum Discussion
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...
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?
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?