Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
erhan_79
Post Prodigy
Post Prodigy

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 Capture1.JPG

 i want to create a new table kia a pivot ,  as with below infos 

 

Capture2.JPG

 

i will wait for your good news thank you very much 

1 ACCEPTED SOLUTION

@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

View solution in original post

6 REPLIES 6
amitchandak
Super User
Super User

@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

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 NoModelRequest DateQtyVendor
1Finish Good1.02.202010Vendor A
2Accessories1.02.202020Vendor A
3Finish Good1.04.202020Vendor B
4Finish Good1.04.202010Vendor B
5Accessories1.02.202010Vendor A
6Accessories1.04.202015Vendor B

 

 

Table Delivery 

 

Inbound NoModelDelivery DateQtyVendor
7Finish Good1.02.20205Vendor A
8Accessories1.02.202010Vendor A
9Finish Good1.04.202010Vendor B
10Finish Good1.04.202020Vendor B
11Accessories1.02.20205Vendor A
12Accessories1.04.202010Vendor B

 

 

@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

thank you very much dear @amitchandak  it is working have a good day.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.