Forum Discussion
Create new row in same table
Hello,
Using the following sample data, I need to create new rows for anything with a "Y" in "New Business Uplift on Modify" column, which would populate the "Order Type" as "New Business", and populate the "Customer Annual" column with the relevant figure from the "Modify Revenue" column. What's the best way to do this?
| 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 |
Hi ben249 ,
Please try below codes to create calculated columns.
New Order Type = IF ( 'Table'[New Business Uplift on Modify] = "Y", "New Business", 'Table'[Order Type] )New Customer Annual = IF ( 'Table'[New Business Uplift on Modify] = "Y", 'Table'[Modify Revenue], 'Table'[Customer Annual] )Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi ben249 ,
Please try below codes to create calculated columns.
New Order Type = IF ( 'Table'[New Business Uplift on Modify] = "Y", "New Business", 'Table'[Order Type] )New Customer Annual = IF ( 'Table'[New Business Uplift on Modify] = "Y", 'Table'[Modify Revenue], 'Table'[Customer Annual] )Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.