Forum Discussion

Jeremyd's avatar
Jeremyd
New Member
3 years ago

Time spent vs time available

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?

Need Help

1 Reply

  • Mahesh0016's avatar
    Mahesh0016
    Super User
    3 years ago

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