Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Connect different Calendars!

Good day!   Please help!   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, m...
Need Help
olgad's avatar
olgad
Resident Rockstar
3 years ago

Hi Aidana, 
create two relationships, one is to PlannedFinishDate (you have that one already), the second one is to 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. 
Example:
Calculate(Count(Activities), USERELATIONSHIP(CalendarDate, ActualFinishDate))
Instead of Count(Activities) shall be your measure how you do the calculation, sum, count etc. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks!

    I did this formula:

    8. Formula = CALCULATE('Activities Schedule'[11. Activity7], USERELATIONSHIP('Activities Schedule'[ActualFinishDate], 'Calendar'[Date]))
     
    Now it does not show those dates that do not match the Planned Finish Date.
     

     

    • olgad's avatar
      olgad
      Resident Rockstar
      3 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        yes, Month an week

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Activity = count of all activities in the cloumn