Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I need to create a table that is a union of more tables.
This tables are read from different pbix files using direct query. I used a preview function called power BI datasets under data hub items menu.
Every tables contain only measures.
I used union function and i create rows using ROW function.
Every row contains measures from one table.
UNIONTABEL =
Union (
row("Column1",table1[measure1],...,"ColumnN",table1[measureN])
row("Column1,table2[measure1],....,"ColumnN",table2[measureN])
row("Column1",tableN[measure1,....,"ColumnN",tableN[measureN])
)
So, i obtain an union table, but if update dataset, data in my UNIONTABLE is not update. But if i check measeures in tables, them are updated whit new data read on origin file.
I try to find a solution but i'm stuck.
Thanks a lot
Riccardo
@rcks79 , Measure can not take a slicer of filter values when used in the calculated table. Only new rows of data will added when refreshed
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |