DAX to Calculate Room Utilization by Hour and Day
Hi PBI Community, I'm trying to calculate hourly % utilization with a sample of the following data points. I want to display a matrix visual that shows by day and hour, the percentage of rooms occupied (similar to the last image). I found this DAX on this site but couldn't get it to calculate correctly. I also need to ensure that the appropriate utilization is calculated for the hours inbetween "In" and "Out." For instance, if 'In' is 8am and 'Out' is 10am, I need to make sure that the DAX accounts for the 9am hour. Sorry -- new to DAX and looking to learn from the community. _______________________ Measure Utilization = var _occupied = CALCULATE(COUNT('Source'[Guest]), FILTER(ALLSELECTED('Source'), 'Source'[In]<=MAX('Table Time'[Time])&&'Source'[Out]>=MAX('Table Time'[Time])&&'Source'[Date]=MAX('Table Calendar'[Date]))) var _utilization = DIVIDE(_occupied,20) // for 20 rooms return IF(_utilization = BLANK(),0,_utilization)
Compare hour from different table
Hi all I have a column Dim Hours, that contains 24 hours . table a and I have other column in other table that contains some hours for exemplo table b 12:00:00 12:30:00 17:00:00 I would like to compare this date for exemplo IF( tableA.hour >= tableB.hour,1,0) The problem is that the table A there are a lot line and Table B they are 10 line for exemplo, so i need compare. Thanks a lot
