Forum Discussion
erhan_79
Post Prodigy
Post ProdigyPivot 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 ta...
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
erhan_79Post Prodigy
Post Prodigydear 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
Super User
Super Usererhan_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 - amitchandak
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
- erhan_79
thank you very much dear amitchandak it is working have a good day.