cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mpatel181 Regular Visitor
Regular Visitor

Pivot data from multiple tables

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

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!




2 REPLIES 2
Highlighted
Super User
Super User

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!




mpatel181 Regular Visitor
Regular Visitor

Re: Pivot data from multiple tables

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