Measure Updates After Scheduled Refresh

Question

I have scheduled refresh setup for one of my reports.

One of the measures, that helps calculate revenue for the current week, auto-updates at the end of the week on Friday.

I use the following formula to calculate revenue based on the current week:

Current Week Fcst = CALCULATE([SelectedMeasure1],FILTER('Trend Data','Trend Data'[WeekNum] = WEEKNUM(NOW())))

I also have several other measures that help calculate the revenue for last week, two weeks ago, and one month ago.

My issue is that when new data comes in on Friday, my report updates based on the current week's calculations. My scheduled refresh is set up for Friday morning. However, on Monday morning, my formulas update based on the new week and display blanks for the current week (because there is no data for this week yet). The last week's measure displays revenue that should be displayed for the current week.

I was wondering why the measure updates after the scheduled refresh without being triggered? Is there a workaround for this?

amitchandak · Answer

rashmij9 , with help from week start date create a column like this and save it on this week
&nbsp;
Week Type = Switch( True(),[start week]&lt;=Today() &amp;&amp; [end date]&gt;=Today(),"This Week" ,[start week]&lt;=Today()-7 &amp;&amp; [end date]&gt;=Today()-7,"Last Week" ,[Week Name])
&nbsp;
refer week start and end
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482https://medium.com/chandakamit/cheat-sheet-any-weekdays-week-start-date-just-one-variable-apart-6b2e6f593958

Forum Discussion

Measure Updates After Scheduled Refresh

1 Reply

Related content

update scheduling

MySQL Scheduled Update

Scheduled pipelines failing

Schedule refresh

App not updating