cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Boudewijn Frequent Visitor
Frequent Visitor

undefined

Power BI PBI Grafiek.PNGPBI Relatie overzicht.PNG

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: undefined

hi, @Boudewijn

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

Assume that this is my data model

10.PNG

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] ) 

11.PNGdate table

12.PNGleft table

 

13.PNGright 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

14.PNG

 

here is pbix file, please try it.

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

 

Best Regards,

Lin

 

 

 

 

 

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Highlighted
Community Support Team
Community Support Team

Re: undefined

hi, @Boudewijn

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

Assume that this is my data model

10.PNG

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] ) 

11.PNGdate table

12.PNGleft table

 

13.PNGright 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

14.PNG

 

here is pbix file, please try it.

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

 

Best Regards,

Lin

 

 

 

 

 

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.