Forum Discussion
olimilo
Post Prodigy
Post ProdigyCreate a calculated (DAX) table using related tables?
I know this is possible to do with Power Query (or just dropping the fields in a visual, since the tables are related) but I would like to know if this is possible to do with just DAX. I have 2 t...
amitchandak
Super User
Super Userolimilo , In power query you can use merge
Merge Tables (Power Query) : https://youtu.be/zNrmbagO0Oo
In this case DAX summarize should also work
summarize(Table2, Table2[EMP ID], Table1[Name], Table1[Country], Table2[Training], Table2[Date])
Also check Natural Join - https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Because they are joined, you can put all columns as unsummarized in visual
olimiloIs there a reason why Table 2 is used as the table for the SUMMARIZE function and not Table 1?