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
Thank you in advance!
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.
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