Same period as last year in a line chart

[nimp_kp]

Hi

I want to create a line chart that show this years accumulated numbers from february 1st until july 1st, compared to the accumulated numbers in the same period last year.

I have made two measures that calculates the accumulated numbers for 2018 and 2019 but when I use the date column, the two lines are shown side by side.

Any tips to how to create a date column that doesn't show the year, so the lines are shown on top of each other?

[TeigeGao · Accepted solution]

Hi @nimp_kp ,

In your scenario, we can create two calculated column using the following DAx query:

Month = Table1[Data].[Month]
Year = YEAR(Table1[Data])

Then we can create two measures:

2018 = CALCULATE(SUM(Table1[Value]),Table1[Year] = 2018)
2019 = CALCULATE(SUM(Table1[Value]),Table1[Year] = 2019)

The result will like below:

Best Regards,

Teige

[Anonymous]

How did you order the month starting from March?