Add calculated row in power query

Hi ajinkyacgaikwad  ,

 

^{You can input the following code in “Advanced Editor”}

 

let

    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8sxLyUxU0lEyMNQFIiMDIwMgx1QpVidayTkjMw9DytAALOeUUVqSmIchCZbDMNIQyDHDbiRIytAIh5EgSWOwXHh+UU4KhisNsMuBrQPKxQIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Country = _t, Date = _t, Value = _t]),

    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Country", type text}, {"Date", type date}, {"Value", Int64.Type}}),

    #"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Country]), "Country", "Value"),

    #"Inserted Multiplication" = Table.AddColumn(#"Pivoted Column", "Multiplication", each [World] * [India], Int64.Type),

    #"Removed Columns" = Table.RemoveColumns(#"Inserted Multiplication",{"Multiplication"}),

    #"Added Custom" = Table.AddColumn(#"Removed Columns", "Remaining countries", each [World]-[India]-[China]-[Bhutan]),

    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Added Custom", {"Date"}, "Attribute", "Value")

in

    #"Unpivoted Other Columns"

 

 

^{The output is as follows}

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

^{Best Regards,}

^{Xinru Zhu}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}