Merge Calendar in query

[ChadSmith22]

Hi Everyone

So I am working with Project for the Web solution accelerator. I need to build a matrix (heatmap) that shows forecast work per day but also taking into consideration the resources calendar. then i can show forecast work per day and "remaining availability" against the resources calendar.

Microsoft stores the resources calendar as its own individual API for every resource in a calendar table.

Table 1 (resources): Resource ID, Calendar

Table 2 (calendar): Calendar ID, Resource ID, Time Off Days, Time off Date , Time off Type etc.. (coudl be like 20 rows in calendar entity for each resource)

So if every resource has its own calendar ID - how do i get to the availability formula? (per day)

Time off is all by date/date ddmmyyyy in calendar entity

all help urgently appreciated... guessing this is tricky??

[Anonymous · Accepted solution]

Hi @ChadSmith22 ,

You can merge two tables. 

Matching columns are the Resource ID from the Table 1 and the Table 2.

Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AnkitKukreja]

Hi! @ChadSmith22 

Is it possible to share the sample data and your expected result?