Forum Discussion

MurtoMan's avatar
MurtoMan
Helper I
5 years ago
Solved

How to union tables?

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!

  • 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.

2 Replies

  • S_JB's avatar
    S_JB
    Resolver III

    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.