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

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

    • 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?