Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 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
    3 years ago

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

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous ,could you please show how you have implemented? or if you could share your PBIX after removing sesitive data?

Anonymous's avatar
Anonymous
Not applicable
3 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
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 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
        3 years ago

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