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,
In my case there are 12 identical tables for each month (the content is different, of course).
My goal is to create a filter or slicer by months.
All tables have a DATE/TIME column 'CreatedOn' (e.g 3.10.2020 10:11:00) and a TIME column 'Working time' (e.g 7:45)
In January file there are calulated measures like Working hours (sec), Working hours (h), Duration (h) which are calulated from 'Working time'
For filtering purposes I want to union all 12 tables, but PowerBI says all tables must have equal number of columns.
Is it true that I have to copy those 3 measures to each 12 tables??
Is there any other way to combine those tables?
My goal is to get a filter or slicer by moths.
All help is much appreciated!
Solved! Go to Solution.
A potential solution could be to delete the calculated measures from the January table before unioning the tables.
Then create the calculated measures after unioning the 12 tables.
A potential solution could be to delete the calculated measures from the January table before unioning the tables.
Then create the calculated measures after unioning the 12 tables.
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 |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |