undefined

[Boudewijn]

Power BI 

Power BI Desktop: How can I combine 2 Tables with 2 date columns in one Graph with a common timeline (x-axis)?

[v-lili6-msft · Accepted solution]

hi, @Boudewijn

After my test, you could do these follow my steps as below:

Assume that this is my data model

Step1:

Create a date table and create a Year Month Number column for each data table

Year Month Number = YEAR ( 'Date'[Date] ) * 100 + MONTH ( 'Date'[Date] ) 

date table

left table

right table

Step2:

then create a measure

Measure = var maxdate=MAX('Date'[Year Month Number]) return
CALCULATE(SUM('LEFT'[Sales]),FILTER('LEFT',maxdate='LEFT'[Year Month Number]))+CALCULATE(SUM('RIGHT'[Sales]),FILTER('RIGHT',maxdate='RIGHT'[Year Month Number])
)

Step3:

Drag the date field form date table and the measure into chart visual

here is pbix file, please try it.

https://www.dropbox.com/s/ny6bnkqp92skvdq/undefined.pbix?dl=0

Best Regards,

Lin