Forum Discussion
Add column and rows to source table
Hi All,
i have the below Source table. i need to add 2 rows for each row in the output table with 2 extra columns as below
Source table
| portfolio_code | class_scheme_code | class_scheme_node_name | class_scheme_node_name_benchmark | class_scheme_node_code | date_from | date_to | contribution_base | sequence | return_portfolio_base | log_portfolio_base | log_benchmark_base | log_contribution_base | Excess_Return | ExcessReturnsHeader | client_name | client_type | Portfolio_Node_Name_Override | Benchmark_Node_Name_Override |
| PORT | PORTCS | REAL ESTATE | REAL ESTATE Benchmark | REALEST | 01/01/2023 | 01/01/2023 | 0 | .000.002.001.000.000 | 0 | 100 | 200 | 0 | 100.00 | Excess Returns | Client | P | Real Estate | |
| PORT | PORTCS | REAL ESTATE | REAL ESTATE Benchmark | REALEST | 01/02/2023 | 01/02/2023 | 0 | .000.002.001.000.000 | 0 | 102 | 100 | 0 | 150.00 | Excess Returns | Client | P | Real Estate | |
| PORT | PORTCS | EQ | EQ Benchmark | CDNEQ | 01/02/2023 | 01/02/2023 | 0 | .000.005.001.000 | 0 | 120 | 5 | 0 | 200.00 | Excess Returns | Client | P |
New Column: Asset will have data from class_scheme_node_name,class_scheme_node_name_benchmark and ExcessReturnsHeader columns
New Column: Returns will have data from log_portfolio_base,log_benchmark_base and Excess_Return columns
all the other columns will be repeated in the extra 2 rows added.
Please help
output table
| Asset | Returns | portfolio_code | class_scheme_code | class_scheme_node_name | class_scheme_node_name_benchmark | class_scheme_node_code | date_from | date_to | contribution_base | sequence | return_portfolio_base | log_portfolio_base | log_benchmark_base | log_contribution_base | Excess_Return | ExcessReturnsHeader | client_name | client_type | Portfolio_Node_Name_Override | Benchmark_Node_Name_Override |
| REAL ESTATE | 100 | PORT | PORTCS | REAL ESTATE | REAL ESTATE Benchmark | REALEST | 01/01/2023 | 01/01/2023 | 0 | .000.002.001.000.000 | 0 | 100 | 200 | 0 | 311.00 | Excess Returns | Client | P | Real Estate | |
| REAL ESTATE Benchmark | 200 | PORT | PORTCS | REAL ESTATE | REAL ESTATE Benchmark | REALEST | 01/01/2023 | 01/01/2023 | 0 | .000.002.001.000.000 | 0 | 100 | 200 | 0 | 311.00 | Excess Returns | Client | P | Real Estate | |
| Excess Returns | 311.00 | PORT | PORTCS | REAL ESTATE | REAL ESTATE Benchmark | REALEST | 01/01/2023 | 01/01/2023 | 0 | .000.002.001.000.000 | 0 | 100 | 200 | 0 | 311.00 | Excess Returns | Client | P | Real Estate | |
| REAL ESTATE | 102 | PORT | PORTCS | REAL ESTATE | REAL ESTATE Benchmark | REALEST | 01/02/2023 | 01/02/2023 | 0 | .000.002.001.000.000 | 0 | 102 | 100 | 0 | 314.00 | Excess Returns | Client | P | Real Estate | |
| REAL ESTATE Benchmark | 100 | PORT | PORTCS | REAL ESTATE | REAL ESTATE Benchmark | REALEST | 01/02/2023 | 01/02/2023 | 0 | .000.002.001.000.000 | 0 | 102 | 100 | 0 | 314.00 | Excess Returns | Client | P | Real Estate | |
| Excess Returns | 314 | PORT | PORTCS | REAL ESTATE | REAL ESTATE Benchmark | REALEST | 01/02/2023 | 01/02/2023 | 0 | .000.002.001.000.000 | 0 | 102 | 100 | 0 | 314.00 | Excess Returns | Client | P | Real Estate | |
| EQ | 150 | PORT | PORTCS | EQ | EQ Benchmark | CDNEQ | 01/01/2023 | 01/01/2023 | 0 | .000.005.001.000 | 0 | 150 | 25 | 0 | 315.00 | Excess Returns | Client | P | ||
| EQ Benchmark | 25 | PORT | PORTCS | EQ | EQ Benchmark | CDNEQ | 01/01/2023 | 01/01/2023 | 0 | .000.005.001.000 | 0 | 150 | 25 | 0 | 315.00 | Excess Returns | Client | P | ||
| Excess Returns | 315 | PORT | PORTCS | EQ | EQ Benchmark | CDNEQ | 01/02/2023 | 01/02/2023 | 0 | .000.005.001.000 | 0 | 120 | 5 | 0 | 315.00 | Excess Returns | Client | P |
2 Replies
Sure foodd
please find the pbix attached
https://drive.google.com/file/d/1zYLrAdJK7SZZ-tBbex4rZ7RcobhJTZ2f/view?usp=drive_link
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
