Add subtotal Rows

Hi,

Create Conditional Column in Power Query (find steps)
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("bY5BD4IwDIX/yrIzJkBAwtEQNJ71RjiUOc1i15ltEP33FuFi9Na+973Xdp1szGRws8tkItunggmiccRLlqayT778kzMoNA1Ad0uaIkv5SrWoVfROwYo2MKB+jIiGbiJ6oHB13mrPVlFu/0YOCHRhnMeyyD/IkUL0o138s+aAs0LN1cIt3azXVfUL743XYofgrQivELWdD9f8a/8G", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Code for Area" = _t, Activities = _t, Volumes = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Code for Area", type text}, {"Activities", type text}, {"Volumes", Int64.Type}}),
#"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Group/Category", each if [Code for Area] = "Civil-A1" then "Civil Work at Area 1" else if [Code for Area] = "Electrocal-A1" then "Electrical Work at Area 1" else if [Code for Area] = "Instrum-A1" then "Instrument Work at Area 1" else null)
in
#"Added Conditional Column"

Or create Calculated Column in DAX

Group/Category = SWITCH(TRUE(),

Data[Code for Area]="Civil-A1","Civil Work at Area 1",

Data[Code for Area]="Electrocal-A1","Electrocal Work at Area 1",

Data[Code for Area]="Instrum-A1","Instrument Work at Area 1")

Create Matrix table in Power bi

If any question, please LET ME know

If solve, mark this answer as SOLUTION
If helps you, LIKE this comment/Kudos.

Thanks