Expand data to multiple rows or create a measure?

Hi,

I have achieved my desired result, I just want to know if there is a better way, because the way I have done it, results in a very large data set.

I want to see if this can be achieved in another way?

I have 3 source tables,

1) A Vehicle table which shows each vehicle and a valid from and to date

2) A Maintenance table which shows each date that the vehicle is being maintained

3) A Trip table which shows each date the vehicle did a trip and how far it travelled.

My goal is to get a chart or table of data that shows, for every single date between the vehicles valid from and to date,

is it available to use? (if there is a maintenance date, then it is not available) and how far it travelled on each date.

I have achieved this by expanding my vehicle table in Power Query (in M), so there is one row for every date between its validity dates.

Then for each row, I determine if it is available by doing a calculate with a filter to look up if there is maintenance on that date or if a trip was done on that date.

This creates a VERY LARGE dataset as I have thousands of records being expanded thousands of times.

Here is a basic example.

Here are my base tables.

Here is the resulting table

Here is an example of a chart I want to achieve (i have a measure that counts the rows, that shows the count per "usage" type

I really appreciate your input.