Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Use two dates from one table against a date table

Hi,

 

I have two tables.

 

Table1

date

Month

Year

 

Table2

Start date

End date

 

I have the join both ways between Table1[date] and Table 2[start date].

 

This is fine when I am wanting to have a measure to count how many tickets where started in a month.. however how could I have a table with number started and number finished using the month and year from the date table?

 

Thanks

 

Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 

    to calculate the number finished you need to create an inactive relationship between 'Date'[Date] and 'Table'[Finish Date] then you can CALCULATE activating the relationship using USERELATIONSHIP 

1 Reply

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi Anonymous 

    to calculate the number finished you need to create an inactive relationship between 'Date'[Date] and 'Table'[Finish Date] then you can CALCULATE activating the relationship using USERELATIONSHIP