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

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'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!

    • Dan84980's avatar
      Dan84980
      Regular Visitor
      9 years ago

      I haven't got any answer yet!

      • DoubleJ's avatar
        DoubleJ
        Solution Supplier
        9 years ago

        I'm afraid this is not possible

  • Irussaa's avatar
    Irussaa
    Helper I
    7 years ago

    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?