Refresh Dahboard to the day before

[christianfcbmx]

Hi Dear Community,

I need and advice on how to set my dashboard to be updated automatically to the day before, meaning not considering the data related to he actual date

Any Suggestion?

Thank you in advance!

[chethan]

@christianfcbmx Lets refresh for today & Set RLS for Day before date & assign in Service

Regards,

Chetan K 

[Anonymous]

It's not perfect, but what if you set the Dataset refresh to only refresh once a day, make the time displayed 11:30pm.  You would then capture almost all of your data from the current day, and when users look at the dashboard, the last update will be from the previous day. (Except for those looking just post your dataset refresh).  You could also mess with the timezones to get closer to your target time for the data to be refreshed. 

[christianfcbmx]

Im trying to solve it over desktop with some DAX...any Idea?

[dedelman_clng]

It wasn't in DAX, but in PowerQuery I added a custom line to only populate the date table through the current date.  It could be modified to be the previous date.

= Table.SelectRows(#"Changed Type", each [Date] <= Date.From(DateTime.LocalNow()))

I suppose removing the " = " would get the date table to only have values up to yesterday.

Hope this helps

David