Forum Discussion
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.
Expected Result
Hi Anonymous,
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
2 Replies
Hi Anonymous,
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