DAX measure to insert new values into a list or table

[databot_kd]

Hi community, 

Is it possible to have a DAX measure that can insert values into a table or list. 

For example i can write a measure to return distinct values from my table so it looks like this:

I want to create a new DAX formula that will append two additonal values into this list/table so it looks like this now:

The values Total Budget and Total Amount added to the table 

Thanks in advance 

[Igna]

Hello,

You can do that with Power Query. 

Open the Power Query editor on the table that you want and edit the code using this :

let
    Source = YourTable,
    AppendValues = Table.FromList({"Total Budget", "Total Amount"}, Splitter.SplitByNothing()),
    AppendedTable = Table.Combine({Source, AppendValues})
in
    AppendedTable

Igna

[Ahmedx · Accepted solution]

Refer to this solution

https://community.fabric.microsoft.com/t5/Desktop/Matrix-Table-Custom-Row-Total/m-p/3468437#M1148954