Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi Team,
I have following tables I need to create data model using bridge table in power BI need your support for the same. Here is my data set.
Sales:
Year | Month | Branch | Item Number | Customer Number | Invoice Number | Order Number | Salesman Number | Invoice date | Sales Amount | Sales Qty | Cost Amount | Margin Amount | Unit of Measure |
2014 | Jan | 40 | 111 | 231 | 4567 | 1 | 11 | 01-01-2014 | 234 | 25 | 25 | 50 | Rs |
2014 | Feb | 40 | 111 | 232 | 4568 | 1 | 11 | 02-02-2014 | 500 | 30 | 30 | 40 | Rs |
2014 | march | 40 | 111 | 233 | 4569 | 1 | 11 | 03-03-2014 | 200 | 40 | 40 | 25 | Rs |
2013 | Jan | 40 | 121 | 234 | 4570 | 1 | 11 | 04-01-2013 | 500 | 24 | 24 | 40 | Rs |
2014 | Feb | 40 | 121 | 235 | 4571 | 1 | 12 | 05-01-2014 | 483 | 20 | 20 | 50 | Rs |
2012 | Mar | 41 | 121 | 236 | 4572 | 1 | 12 | 06-01-2012 | 532.8 | 23 | 23 | 40 | Rs |
2014 | Apr | 41 | 131 | 237 | 4573 | 1 | 12 | 07-01-2014 | 582.6 | 20 | 20 | 25 | Rs |
2014 | May | 41 | 131 | 238 | 4574 | 1 | 12 | 08-01-2014 | 632.4 | 24 | 24 | 40 | Rs |
2014 | Jun | 41 | 131 | 239 | 4575 | 1 | 13 | 09-01-2014 | 682.2 | 20 | 20 | 40 | Rs |
2014 | Jul | 41 | 131 | 240 | 4576 | 1 | 13 | 10-01-2014 | 732 | 23 | 23 | 25 | Rs |
2014 | Aug | 42 | 131 | 241 | 4577 | 1 | 13 | 11-01-2014 | 781.8 | 20 | 20 | 40 | Rs |
2011 | Sep | 42 | 131 | 242 | 4578 | 1 | 14 | 12-01-2011 | 831.6 | 25 | 25 | 50 | Rs |
2014 | Oct | 43 | 141 | 243 | 4579 | 1 | 14 | 13-01-2014 | 881.4 | 30 | 30 | 40 | Rs |
2010 | Nov | 43 | 141 | 244 | 4580 | 1 | 14 | 14-01-2010 | 931.2 | 40 | 40 | 25 | Rs |
Inventory:
Branch | Item Number | On Hand Qty |
40 | 111 | 356 |
41 | 121 | 400 |
42 | 131 | 500 |
43 | 141 | 100 |
Purchasing:
Year | Month | Branch | Item Number | PO Number | Req Delv Date | PO Amount | Ordered Qty |
2010 | nov | 40 | 111 | 21 | 01-01-2010 | 3000 | 45 |
2011 | sept | 41 | 121 | 22 | 01-01-2011 | 4000 | 32 |
2012 | mar | 42 | 131 | 23 | 01-01-2012 | 5000 | 19 |
2013 | jan | 43 | 141 | 24 | 01-01-2013 | 6000 | 6 |
2014 | jan | 44 | 151 | 25 | 01-01-2014 | 7000 | 56 |
2015 | march | 45 | 161 | 26 | 01-01-2015 | 8000 | 40 |
My data model should look like this :
Hi @vikasmahajan ,
For this you can manage the relationships inside Power BI look at the link below:
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português