Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |