Working with weeks in visualizations

[Anonymous]

Hoping for some help.

Im not an advanced user (simply the employee at the company that sucks the least when it comes to computers, so I was tasked with maintaining the company Power Bi).

I have a dashboard on the TV showing the number of booked meetings the telesales department has done this month and this week (rather simple just a count filtered by current month and current week).

Now the department got a new boss and he also wants a runrate for the bookings for the same period (an estimate for how the month and week will end)... For the month its rather simple, I simply made a new measurement

monthEstimate = (COUNTAX(FILTER(MeetingsBooked;[datetimeRealMeetingBookedAt (dag)]<=TODAY());[BasicInfoId])/DAY(TODAY()))*22

(22 is the workingdays in an average month)

But the new boss also wants a measurement that shows the estimate for the week... And i'm drawing a blank about how to do this.  Any help?

Second thing...

In our visualization the weeks start Sunday (thats simply PowerBi default and I haven't bothered changing this to monday eventhough that is more correct here in Sweden where the weeks start monday).

The poblem im having is that the new boss wants the visualizations to start the weeks on Saturdays and run through to the following Friday (week start: saturday, week end: friday).

And I can't get my head around how to do this... Any help?

Finally... As the dashboard is running on a TV screen this should always be up-todate... So the report needs to be running in Direct Queary mode (connected to the company SQL database).

[v-xicai]

Hi  @Anonymous ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

Hi @Anonymous ,

For your first and second questions, I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

For your third question, If your dataset is only from on premise data source, you need to install the Gateway and configure it correctly . See:On-premises data gateway ,Manage your data source - SQL Server .

If your dataset combines on-premises and cloud data sources at the same time, you need select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.