Get yesterday values from Calculated formula

[JessicaM]

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!

[JessicaM]

@themistoklis  thanks a lot! Now it is working perfectly! 🙂

Thanks!

[themistoklis · Accepted solution]

@JessicaM 

Can you try the following formula:

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