Linking dates from two sources

[pstp]

I am trying to link dates for data from SQL and Excel. In my report, I have a visualization (line graph) which has an axis based on calendar week. Both data from SQL and Excel have this measure/column. Is there a way to link the two so both data can be displayed on the same visualization along the same timeline? Thanks!

[v-lili6-msft]

hi  @pstp 

You could just create two relationship:

1. between calendar date table and SQL table 

2. between calendar date table and Excel table 

like this:

then create visual or measure, just use the date field from this dim date table.

https://radacad.com/do-you-need-a-date-dimension

Regards,

Lin

[parry2k]

@pstp since you already have a date dimension in your model, set relationship from this date dimension with your sql and excel data source and in visual, use columns from this date dimension and measure/columns from respective sql and excel table. seems like you have all the pieces in place and it should work until I'm missing something.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡