Forum Discussion
Linking dates from two sources
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!
2 Replies
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.⚡
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
