Forum Discussion

anguyen83's avatar
anguyen83
Frequent Visitor
9 years ago
Solved

Create a new table from columns from existing tables

  Hi I am looking to do the following but I don't know how to go about doing it. I know how to do it via MS access but it's difficult to see how it'll work in Power BI   This is what I would like ...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi anguyen83,

     

    You can simply use below formula merge these tables.

     

    New Table= UNION(SELECTCOLUMNS(Table1,"Stage","TS1","Date",[TS1]),SELECTCOLUMNS(Table2,"Stage","TS2","Date",[TS2]),SELECTCOLUMNS(Table3,"Stage","TS3","Date",[TS3]),SELECTCOLUMNS(Table4,"Stage","TS4","Date",[TS4]))

     

    Regards,

    Xiaoxin Sheng

kranthi77's avatar
kranthi77
New Member
4 years ago

Hi Team,

 

Currently I have used queries to get average values of each PR stages and used them in clustered column chart as shown below.

 

I have a requirement from our stakeholder that bars in column chart should be visible separately similarly like visual below.

 

 

 I think it is possible only if we can create a table like this within Power BI, please help me understand to create a table like this.

Thanks and Regards,

Kranthi Kumar