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.

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

Hi Anonymous ,

 

You can create a measure as below and use it as filter on the visuals you want to apply this filter.

 

Measure = 
IF ( MAX ( 'Table'[Date] ) <= TODAY () - 1, 1, 0 )

 

Thanks,

Samarth

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Not Working !!

 

  • Samarth_18's avatar
    Samarth_18
    Icon for Community Champion rankCommunity Champion
    4 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
      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.