Forum Discussion
Combining a Calendar with Date Driven Data
Hello, New user to the Power B.I Community. I was wondering if I could get some help on a problem. I work for a rental company and the goal is to combine calendar dates with dates vehicles ar...
dramus
Continued Contributor
Continued ContributorDo you need to know which vehicles were not rented, or just the number that were not rented on a particular day?
I would have to know the vehicle that was not rented
- dramusYuck. How many vehicles are we talking about? Creating a column for each would seem to not be a viable solution. Which was my first thought.
- dramus
Take a look at the DAX function NATURALLEFTOUTERJOIN().
I created the following table, which I think gives you what you want.
All Dates and Vehicles = NATURALLEFTOUTERJOIN('calendar','Vehicle Information')
There needs to be a link between the Calendar and Vehicle Information tables, so that the function knows what to join on.
