2 lines in 1 chart

[noamshn]

Hello everyone,

I have a table with creation date and completion date. I want to make a line chart that will show 2 graphs, the count of creation dates in 1 graph (by month) and the count of completion dates in the second graph (by month).
In the table i created 4 new columns, month and year columns for the creation and completion dates.

After this i created a relationtiop between a calendar table and the month created column. because i cant create another relationtiop when i create the chart the creation line is good but the completion line is not the real data.

what am i doing wrong and how can i fix it?

[noamshn]

@parry2k thank you.
so now i can see the right numbers when i'm not filtering by the year. how should i add the year of each one (completion and creation) in the filter? i created a completion year and creation year column and when i filter with both of them it not showing the real values.

[parry2k]

@noamshn you need to create using completion date as well, but it will be inactive which is fine and then you can add measure to make it active:

Completion Count = 
CALCULATE ( COUNTROWS ( Table ), USERELATIONSHIP ( Table[Completion Date], DateTable[Date] ) )