cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShivT
New Member

Creating new values (Rows) to an existing table

I have a sales table with sales data for each retailer in the database. I know there is further granularity we can provide for certain retailers - I want to apportion these sales values to a lower level of granularity, based on the proportion of sales I can attribute to particular sales values

 

Existing table example:

RetailerSales value (Eur)Date
Retailer A100,0002022

 

I know retailer A can be split out into sub-values based on an apportionment provided by the business:

 

Retailer A sales are made up of:

Retailer 110%
Retailer 220%
Retailer 350%
Retailer 420%

 

So my desired sales table should look like this:

RetailerSales value (Eur)Date
Retailer 110,0002022
Retailer 220,0002022
Retailer 350,0002022
Retailer 420,0002022

 

Can anyone advise on how to achieve this?

3 REPLIES 3
Jayaselvan
Helper I
Helper I

I hope you can do that. I am assuming you have first two tables in your pbi. 

It's just simple by merging them by retailer column. 

After that need to multiply percentage and Sales value. 

 

If it helps please accept this as solution. 

If it helped someway to reach solution, please like. 

yingyinr
Community Support
Community Support

Hi @ShivT ,

Please review the following links and check if they can help you achieve the requirement.

Split Rows based on Condition

Split rows based on condition

If the above one can't help you get the desired result, please provide more sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lbendlin
Super User
Super User

You would do that in your data model. Join the tables according to your business scenario.

 

Note: Power BI cannot add rows to an existing table.  But that's not really what you are asking for.

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors