Forum Discussion
sam_nik12345
Helper II
Helper IIcolumn to row view
My table looks like below. date is date type and connected with date table
| date | sales |
| 2018-01 | 1 |
| 2018-02 | 1 |
| 2018-03 | 1 |
| 2018-04 | 1 |
| 2018-05 | 1 |
I want to achieve below by using DAX.
| date | 2018-01 | 2018-02 | 2018-03 | 2018-04 | 2018-05 |
| sales | 1 | 1 | 1 | 1 | 1 |
Kindly help.
sam_nik12345 , I a matrix visual
Date on column , Sales on values .
Show on row - on
Nothing on row
Check the file attached after signature
1 Reply
- amitchandak
Super User
sam_nik12345 , I a matrix visual
Date on column , Sales on values .
Show on row - on
Nothing on row
Check the file attached after signature