Forum Discussion
Advanced pivot? Advanced matrix view?
Hi
Power BI Matrix Table
Change The alignment of the Column Header. If needed, I will share PBIX file, please let me know.
If solve the requirement, Please mark this answer as SOLUTION and give me Kedos.
Power Query Steps
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wcs7PLUjMq1QwVNJRCkhMzk5MTwWzXUODgKShAYjt7hQAYhsZA0kDQ10DY10jAyMjpVgd7NqNgOzQYBcgaWxgANduAmaDtBtBtccCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [CompanyName = _t, PackageName = _t, SaleCurrency = _t, SaleAmount = _t, BillingCurrency = _t, BillingAmount = _t, BillingDate = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"CompanyName", type text}, {"PackageName", type text}, {"SaleCurrency", type text}, {"SaleAmount", Int64.Type}, {"BillingCurrency", type text}, {"BillingAmount", Int64.Type}, {"BillingDate", type date}}),
#"Inserted Month Name" = Table.AddColumn(#"Changed Type", "Month Name", each Date.MonthName([BillingDate]), type text),
#"Inserted Year" = Table.AddColumn(#"Inserted Month Name", "Year", each Date.Year([BillingDate]), Int64.Type),
#"Reordered Columns" = Table.ReorderColumns(#"Inserted Year",{"CompanyName", "PackageName", "SaleCurrency", "BillingCurrency", "SaleAmount", "BillingAmount", "BillingDate", "Month Name", "Year"})
in
#"Reordered Columns"