Forum Discussion
Pivot Creating help
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
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
6 Replies
erhan_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
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
