Want date to automatically start at N-1

[UKDoc]

Hello,

Newbie to forum and BI.

I have a data set that gets updated daily. Post daily refresh, the current day data is always incomplete (due to in flight processing).

What I want to do is show 30 days of data, but start at N-1 and finish at N-31, hence always exclude the current day.

Many thanks in advance

Gavin

[AntonioHR_ · Accepted solution]

mm then a measure like this maybe works:

CALCULATE(SUM/whatever(data); DATEDIFF(YourDateColumn;TODAY();  DAY) >= 2 && DATEDIFF(YourDateColumn;TODAY();DAY) <= 32)

[AntonioHR_]

Hello,

If you have a Date Column you can use it as relative date filter. Select Last 30 days and turn off Including today.

[UKDoc]

I did try that previously but tried again, and discovered my ask was incorrect and was out by another day. Sorry.

I have a data set that gets updated daily. Post daily refresh, I don't get any of today's data, I get yesterday's data is always incomplete (due to in flight processing).

What I want to do is show 30 days of data, but start at N-2 and finish at N-32, hence always exclude the current day.