Forum Discussion
Post ProdigyPivot Creating help
erhan_79 ,
Find the file attached after the signature.
- Created Dimension
- Create Date table
- Month Sort column in date table -Marked as sort for month year
- Created new measures
Super Usererhan_79 ,
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
erhan_79dear 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 ?
- amitchandak
erhan_79 , Share some sample data in text format. I will create pbix and share back
- erhan_79
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