Forum Discussion

JessicaM's avatar
JessicaM
Frequent Visitor
5 years ago
Solved

Get yesterday values from Calculated formula

Hi!

 

I´m trying to get the values regarding yesterday. I have a calendar table and the information that I want to calculate in another table. I´m using this formula:

CALCULATE(COUNTROWS(tableA),DATEADD('Calendar Table'[Date] = TODAY(),-1,day))

The goal is to get the number of rows created yesterday (also I have the same issue when I try to get data from 7 days before)

 

Any ideas about why is not working?

Thanks!

Need Help
  • themistoklis's avatar
    themistoklis
    5 years ago

    JessicaM 

     

    Can you try the following formula:

    Measure = CALCULATE(COUNTROWS(tableA), Filter('Calendar Table', 'Calendar Table'[Date] = TODAY()-1))

     

2 Replies

  • themistoklis's avatar
    themistoklis
    Community Champion
    5 years ago

    JessicaM 

     

    Can you try the following formula:

    Measure = CALCULATE(COUNTROWS(tableA), Filter('Calendar Table', 'Calendar Table'[Date] = TODAY()-1))