Forum Discussion

benjamincoady's avatar
benjamincoady
Helper I
6 years ago
Solved

Dates Field from Different Data Sources Not Separating

Hi,    I am trying to bring in 2 different datasets, they are similar but have their differences. I am trying to create a bar chart showing the sum of "Happy Scores" against the date when the surve...
Need Help
  • benjamincoady's avatar
    benjamincoady
    6 years ago

    All sorted, needed to brush up on my Star Schema and create primary keys between the data tables. For anyone looking to work with data sets within the same dashboard, Ralph Kimballs Dimensional Modelling Techniques book is fantastic and goes through this topic comprehensively. 

     

    Thanks for everyones reply! 

dax's avatar
dax
Community Support
6 years ago

Hi benjamincoady, 

If you want to use two measure from different table,  I think you need to use same date axis(you could create a calendar table, then use this date in axis), which should work.

 

Best Regards,
Zoe Zhi

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