Create table and add rows

Hi lg01 ,

This can be achieved with a DAX calculated table like so:

NewTable =
UNION(
    SELECTCOLUMNS(Table1, "Approved?", Table1[Approved?], "Source", "Table1"),
    SELECTCOLUMNS(Table2, "Approved?", Table2[Approved?], "Source", "Table2"),
    SELECTCOLUMNS(Table3, "Approved?", Table3[Approved?], "Source", "Table3"),
    SELECTCOLUMNS(Table4, "Approved?", Table4[Approved?], "Source", "Table4")
)

 
Before implementing this, make sure to replace the tables with your actual tables and add additional lines based on the number of tables you have. 

If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

Thanks,

Samson

Connect with me on LinkedIn

Check out my Blog

Going to the European Microsoft Fabric Community Conference? Check out my Session