Hi,

I have imported data into PowerPivot via Power Query into the data model.  I have created a calendar table, with bank holidays in order for me to calculate working days etc. The data relates to a query management, and includes columns 'date opened' and 'date resolved'.  
I want it to result in a simple summary pivot table which shows : date , count of date opened & count of date resolved.  I.e. how many new queries were opened in the month, how many were resolved.

I have created the relationship from the calendar table to 'date opened', but as you cannot have multiple active relationships, I cannot seem to get an accurate measure of the queries resolved in the same time period.  I have seen what looks like a PBI only answer, where you can use a measure to provide the result, but can't make it work in my data model.  The other option appears to be a duplicate calendar table, which is less preferred but would provide the answer I need - but I can't find a way to duplicate a whole table in PP (my calendar table was created in PP).

Am I missing a simple answer here?  Any help would be appreciated.  The data feed an excel dashboard (no company license for PBI yet) so I want it to refresh and update all the pivots without the need for any manual work each period.

Thanks in advance