Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there ;
i nned your kind help about below issue
thanks in advance for your kind supports
so , i have two table as below , left one is request table , and right one is the delivery table of these requests.İ want to show quantity difference base on month , each vendor , even with number of difference and with percentange .I tried to paste what i need dears .
These are my tables that i have now
i want to create a new table kia a pivot , as with below infos
i will wait for your good news thank you very much
Solved! Go to Solution.
Find the file attached after the signature.
You need to common Vendor, Date calendar, Model and you can have a month , qtr, etc in date table.
As the date, the dimension will join Requested date in one table and delivery date in another table, you will able to see data together
Refer to this file
https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0
dear @amitchandak ;
thanks fro the pbix but i am really sorry i could not understand as well ,i am new about power bi , i need a formula to create that new table , is it possible that you can create for me a new formula to create a new table ?
@erhan_79 , Share some sample data in text format. I will create pbix and share back
Dear @amitchandak
thank you very much , i will wait here for your reply
i am sending as below i hope it works for you
table request
Purchase No | Model | Request Date | Qty | Vendor |
1 | Finish Good | 1.02.2020 | 10 | Vendor A |
2 | Accessories | 1.02.2020 | 20 | Vendor A |
3 | Finish Good | 1.04.2020 | 20 | Vendor B |
4 | Finish Good | 1.04.2020 | 10 | Vendor B |
5 | Accessories | 1.02.2020 | 10 | Vendor A |
6 | Accessories | 1.04.2020 | 15 | Vendor B |
Table Delivery
Inbound No | Model | Delivery Date | Qty | Vendor |
7 | Finish Good | 1.02.2020 | 5 | Vendor A |
8 | Accessories | 1.02.2020 | 10 | Vendor A |
9 | Finish Good | 1.04.2020 | 10 | Vendor B |
10 | Finish Good | 1.04.2020 | 20 | Vendor B |
11 | Accessories | 1.02.2020 | 5 | Vendor A |
12 | Accessories | 1.04.2020 | 10 | Vendor B |
Find the file attached after the signature.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |