Reply
Regular Visitor
Posts: 21
Registered: ‎05-25-2018
Accepted Solution

Pivot data from multiple tables

[ Edited ]

Below is the format that I currenly have.  I would like to pivot the table where the Months display as columns and Budget numbers as rows.  All the tables are in SSAS bim file so I need this accomplished through DAX.

 

** Note:  Besides the Month colum, all other colums are Measures. 

 

Pivot.jpgExpected Result

Result.jpg


Accepted Solutions
Highlighted
Super User
Posts: 2,150
Registered: ‎09-19-2016

Re: Pivot data from multiple tables

Hi @mpatel181,

 

Put you months names on the columns and then on the optios go to:

  • Values:
  • Show on Rows - On

This will place the measures on the rows and not on columns.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post


All Replies
Highlighted
Super User
Posts: 2,150
Registered: ‎09-19-2016

Re: Pivot data from multiple tables

Hi @mpatel181,

 

Put you months names on the columns and then on the optios go to:

  • Values:
  • Show on Rows - On

This will place the measures on the rows and not on columns.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Regular Visitor
Posts: 21
Registered: ‎05-25-2018

Re: Pivot data from multiple tables

Thank you!!  That worked.  I'm new at PowerBI so thanks for all your help!