Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX Calculated Column

Hi All,   I have a situation where in have to represent the data horizontally instead of vertical representation.   Please refer the below table. I have the data currently as mentioned below.   ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Id on row and MonthYear on the column and Forecasted Gross , Forecasted Net on values of the Matrix

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak  The issue is that while exporting the data it comes vertically only even if I use Matrix so thats the reason I want to create columns horizontally. Also i have few other columns as well in my report and showing them on Matrix is not looking nice. 

 

The want the export also to be horizontal and that can be achieved only if I create columns with the expected data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak If there's a way that my Export also shows the data as in the Matrix dashboard then also I can manage. But the export shows data vertically only and thats the issue for Client. 

     

    Really need help on this as its an issue for the client. 

     

    Regards,

    Himanshu