Forum Discussion

RCarter's avatar
RCarter
New Member
3 years ago

Combining multiple tables with different measures?

Hello,

 

Let me preface this by saying I am very new to PowerBI (and Data Analysis in general). I'm working on a project to bring some student metrics. I have each metric (GPA, SAT, ACT, and Headcount - seperated by year) in it's own table. The metrics I have on rows, and the years I have on columns. My issue is, I want to combine each table so that it looks like the excel screenshot I posted. Does anyone have any guidance?  

Need Help

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, RCarter 

     

    Can you simplify your source data table and provide some sample data for testing? Sensitive information can be removed in advance.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly