Forum Discussion
Solved
Assistance with PowerPivot Data Relational Models.
Hi Everyone:) This is quite basic , I seem to have missed the basic idea I guess.... I have two tables: The first contains both fields: Table1 : ["Name", ]["Address"]. The second table Table2 ...
Without that you pivot nothing and, in general, you don't need the pivot table. From data table you may combine one more table with all information.
Data->Existing connections, select Table1 and open. Right click on it, Table->Edit DAX. Here select DAX
and into expression put something like
EVALUATE SUMMARIZE ( Table1, Table1[Name], Table1[Address], Table2[Area] )Result is
Please see attached.
Without that you pivot nothing and, in general, you don't need the pivot table. From data table you may combine one more table with all information.
Data->Existing connections, select Table1 and open. Right click on it, Table->Edit DAX. Here select DAX
and into expression put something like
EVALUATE
SUMMARIZE (
Table1,
Table1[Name],
Table1[Address],
Table2[Area]
)
Result is
Please see attached.
Even better
Evaluate
ADDCOLUMNS (
Table1,
"Area", RELATED ( 'Table2'[Area] )
)
Thank you so much for your help!
