Forum Discussion

coxy's avatar
coxy
New Member
10 years ago

Graph showing popular times

Hi everyone,   Very much a newbie to PowerBI so apologies if this is a silly question.  I have a large dataset which shows meeting room bookings for the year to date.  This includes seperate fields...
v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

coxy

 

I think you can first create another table which includes all the working minutes. Then we can create a new calculated column in this table which counts the used meeting rooms.

I’ve uploaded my .pbix file here for reference. Please refer to following steps for details.

 

I assume we have an original table as below. We can use the function of split column in Query Editor to split the columns of Start Time and End Time.

 

In another working minutes table, we can create a column with following DAX formula.

Count = 
CALCULATE (
    COUNTROWS ( Table1 ),
    FILTER (
        ALL ( Table1 ),
        Table1[Start Time.2] <= Table2[Time.2]
            && Table1[End Time.2] >= Table2[Time.2]
    )
)

 

At last, drag the stacked area chart into your canvas as below.

 

Best Regards,

Herbert