Schedule Creation

[amandabus21]

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?

[lbendlin]

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-...
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

[amandabus21]

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.