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/Today , If user click on Today or Yesterday data should display , I'm aware that user can select year then Month,week,day but i'm trying to avoid as many as user clicks, I want user to get data straight away if he/she clicks on slicer(Yest/today)

 

Thank you in advance, if possible please share documents  for learning power BI :)

General Comment

8 Replies

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