Connect different Calendars!

Question

Good day!&nbsp;Please help!&nbsp;I have 3 columns with Planned start date, Planned finish date and Actual finish date. In one chart, I need to show how much was planned and how much was done by year, month, and week. The calendar is done like this:Calendar = ADDCOLUMNS(CALENDAR(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MIN(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; min('Activities Schedule'[PlannedStartDate]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;min('Activities Schedule'[ActualFinishDate])),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MAX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; max('Activities Schedule'[ActualFinishDate]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; max('Activities Schedule'[PlannedFinishDate]))),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Year", FORMAT([Date], "yyyy"),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Quarter", "Q" &amp; FORMAT([Date], "Q"),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Month", FORMAT([Date], "mmmm"),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"Week", year([Date]) &amp; "-W" &amp; RIGHT("00" &amp; WEEKNUM([Date], 2), 2))&nbsp;Link made by PlannedFinishDate and Calendar. The chart only calculates those dates with PlannedFinishDate, and does not take the value of ActualFinishDate. I need to have a Plan column and ActualFinish along with it. Is it possible? I tried to create 2 calendars, it still doesn't work. If you connect the ActualFinishDate connection with Calendar, it does not show the plan.

olgad · Answer

Hi Aidana,&nbsp;create two relationships, one is to&nbsp;PlannedFinishDate (you have that one already), the second one is to&nbsp;ActualFinishDate (this will be inactive, as you cannot have two active relationships between two tables)Then,to calculate your measure for the Actualfinishdate, use the function USERELATIONSHIP.&nbsp;Example:Calculate(Count(Activities), USERELATIONSHIP(CalendarDate,&nbsp;ActualFinishDate))Instead of&nbsp;Count(Activities) shall be your measure how you do the calculation, sum, count etc.&nbsp;

anonymous · Answer

Thanks!I did this formula:8. Formula = CALCULATE('Activities Schedule'[11. Activity7], USERELATIONSHIP('Activities Schedule'[ActualFinishDate], 'Calendar'[Date]))&nbsp;Now it does not show those dates that do not match the Planned Finish Date. &nbsp;&nbsp;

olgad · Answer

What is behind&nbsp;'Activities Schedule'[11. Activity7Activity7]. ? Which formula?

anonymous · Answer

Activity = count of all activities in the cloumn

olgad · Answer

Check a couple of things please.Are you using date from calendar on your x axis?&nbsp;

Forum Discussion

Connect different Calendars!

6 Replies

Related content

Calendar Slicer with Different Business Calendars

Connect to Shared Calendars

Custom calendar

Shared Semantic Model - Connectivity Issue from different tenants

Tweaking Financial Calendar