Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter out data by dates till yesterday

Hello Powerbi Developers, I am having one requirement. I am having date column in which data is for whole year, but we want to show dynamically with help of Today() -1 function. eg today is ...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Anonymous , You need to apply measure as visual level filter. Please refer the attached PBIX.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I have this same question - I have a date table that has dates until the end of the year 2023, but I only want my slicer to show dates up until yesterday. 
I tried this measure but it doesn't accept it?

 

Measure =
IF ( MAX ( 'Dates'[FullDateAlternateKey]) <= TODAY () - 1, 1, 0)
 
Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous , You need to apply measure as visual level filter. Please refer the attached PBIX.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Ah, that works. Thank you!

     

    One final thing, if I may.... I have two tables that each have their own date (in the same format). Is there a way to make one slicer do a filter on dates and pull back the necessary statistics? 

    I can share my pbix file if that makes it easier

    • Samarth_18's avatar
      Samarth_18
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Anonymous You could create a date table and join your tables to it. Then use date table on slicer.