Time spent vs time available

[Jeremyd]

I am pulling my calendar events from 365 where i have everything with a standard category.  I can calculate my time spent for each event, and percentage of a day.  But what I can't account for is when there is no event on the calendar.

For example, if i have a 2 hour meeting on Monday, power bi will pull data for Monday and calculate, but if don't have any meetings on Tuesday I should still beable to calculate 8 hours that I was available.

I was thing of new date table with everyday listed and hours available based on weekday and just calculating off of it.

And thoughts?

[Mahesh0016]

 
So you can use filter TREATAS for match with fact table.
For E.g TREATAS(VALUES(Table B[date]),Date[Date]) it's give fact table base result

@Jeremyd I hope this helps you. Thank You!!