column to row view

[sam_nik12345]

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.

[amitchandak · Accepted solution]

@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