Count of date as of yesterday

[xRTP]

Hello,

How can i count data that was dated yesterday and store the counted data to a table for visualization? Thanks

[Samarth_18 · Accepted solution]

Hi @xRTP ,

If I am taking your question correctly then you could use below code:-

Measure =
CALCULATE (
    COUNT ( table[column_to_count] ),
    FILTER ( table, table[date_to_consider] <= TODAY () - 1 )
)

BR,

Samarth

[Samarth_18 · Accepted solution]

Hi @xRTP ,

If I am taking your question correctly then you could use below code:-

Measure =
CALCULATE (
    COUNT ( table[column_to_count] ),
    FILTER ( table, table[date_to_consider] <= TODAY () - 1 )
)

BR,

Samarth

[xRTP]

Thanks again @Samarth_18  but the thing is im calculating for new volume.
Example. In PH date is May 24 and the vendor's new volume date is May 23. So i need to filter all received date dated May 23 for todays new volume. Is it possible? Thanks!

[Samarth_18 · Accepted solution]

@xRTP Is possible for you to explain it with some sample data in text format with expected output?

[xRTP]

Hi @Samarth_18 Actually the solution you provides work! Lol, im filtering the wrong date. What a life saver! Thanks a alot!!