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!