Forum Discussion
Jeremyd
3 years agoNew Member
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 whe...
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!!