topic Re: Schedule Creation in DAX Commands and Tips

Schedule Creation

amandabus21 — Fri, 16 Sep 2022 17:51:47 GMT

Hi,

I have a table from a SQL Server database. It gives me the sheduled amount of buses per day.

This 11/21/21 with the null date is the "base schedule" for the buses.

The schedule only changes if there is another entry, example 12/25/21 for holidays, when the schedule would be modfied.

Therefore the application will place a priority on the base shedule and pull from that unless there is another entry. Then it will bypass the base schedule and go to the new entry for that date.

How can I create a table that gives me the number of schuedled buses per day based on base schedule and bypass entries?

Re: Schedule Creation

lbendlin — Sat, 17 Sep 2022 17:57:35 GMT

Note that Power BI is a reporting tool. It is not a resource scheduling application.

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Schedule Creation

amandabus21 — Mon, 19 Sep 2022 18:21:41 GMT

Im not trying to schedule, I am just trying to report off the schedule.

the expected outcome is to see how many buses adhered to the schedule on one day.