Transformation

[Anonymous]

Hi,  I am new to PowerBI.  

I want to take Month and Year ( here Jul/Jun 20)  from Row1  in Columns . How is that Possible?

S.NO	Name	Rank	Joining date	Status	20-Jul-20	20-Jun-20
1	ABC	A1	3-Jul-20	Active	300	300
2	CDE	A2	6-Jul-20	Active	400	400

[lbendlin]

Use the Unpivot transform. Make sure not to specify the columns that you actually want to target, as these may change.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXJ0cgaRIKaxrldpjq6RAYifXJJZlgoSMzCAkrE60UpGQLaziytIAYhphkWDCVgDiIyNBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [S.NO = _t, Name = _t, Rank = _t, #"Joining date" = _t, Status = _t, #"20-Jul-20" = _t, #"20-Jun-20" = _t]),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"S.NO", "Name", "Rank", "Joining date", "Status"}, "Attribute", "Value")
in
    #"Unpivoted Other Columns"

[OKgo]

If stored as date format, add helper column:

=Date.ToText([Joining date],"MMM-yy")

[nandic · Accepted solution]

Hi @Anonymous ,

If you would like to convert data from columns Jun-2020 and Jul-2020 into rows so that you could use it in report, below are steps.
In Power Query select these 2 columns and then choose unpivot columns > unpivot selected columns.
This way you will have new column which will contain values for both Jun-2020 and Jul-2020 and you will be able to compare them on the report.

Cheers,
Nemanja