Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

naturalinnerjoin date

Hi folks!!   Hope you are doing well, and working from home 😉   I started to fight with NATURALINNERJOIN function...I hope not to lose 😉 I created 2 tables which are agregation of time from 2 ...
  • Anonymous's avatar
    Anonymous
    6 years ago
    Use COMBINEVALUES to create a calculated column in your tables and then create a relationship between them. Using JOINS like this in DAX is not the best solution or even Best Practice.

    Relationships are the best solution and the fastest.

    Best
    D
Anonymous's avatar
Anonymous
Not applicable
6 years ago
I'll tell you more. You should extract Date and Location into their own dimensions and then create a star schema with 2 fact tables. Please see this to know how to correctly model in Power BI:

https://www.youtube.com/watch?v=78d6mwR8GtA&t=1247s

Best
D