Forum Discussion
New row in same table
Hello,
Using the below sample data, for lines where the "New Business Uplift on Modify" is "Y", I need to insert a new row with the "Order Type" as "New Business" and the "Customer Annual" column populated with the figure from the "Modify Revenue" column.
| Order Type | Customer Annual | Modify Revenue | New Business Uplift on Modify |
| Renewal | 460 | 167.89 | Y |
| Renewal | 35 | 0 | N |
| Renewal | 460 | 180.59 | Y |
| Renewal | 35 | 6.99 | Y |
| Renewal | 460 | 145.85 | Y |
| Renewal | 35 | 34.95 | Y |
| Renewal | 5,165 | -701.59 | N |
| Renewal | 35 | 6.99 | Y |
| Renewal | 460 | 167.89 | Y |
| Renewal | 35 | 0.95 | Y |
| Renewal | 441 | 155.21 | Y |
| Renewal | 35 | 34.95 | Y |
| Renewal | 2,885 | -629.77 | N |
Any ideas how I can do this?
Hi ben249 ,
According to your description, this may need to be achieved by creating a virtual table. But the best way to do this is to try to implement this operation in a power query.
Refer to the following solution.Solved: How to add a row to an existing table? - Microsoft Power BI Community
Solved: Creating a new row with IF query in DAX - Microsoft Power BI Community
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi ben249 ,
According to your description, this may need to be achieved by creating a virtual table. But the best way to do this is to try to implement this operation in a power query.
Refer to the following solution.Solved: How to add a row to an existing table? - Microsoft Power BI Community
Solved: Creating a new row with IF query in DAX - Microsoft Power BI Community
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.