Forum Discussion
Formula Help-Calculating Delivery Performance
Dear All ,
İ am new about power bi , so i need your help to solve below problem :
i have two tables , one of them is calling" puchase" which is included purchase orders and order quantitity , and the other one is "delivery " which has the delivery quantities related to purchase table .
İ would like to calculate of performance of the delivery quantities for first scheduled month.
İ created a pbix file but i could not calculate what i want.So i created a screenshot with my comments as below what i need.Also i am sharing the pbix that i created and source excel files to help you to solve the problem more quickly
Here is the link of files :
https://drive.google.com/drive/folders/13DsWGv_eeTAMtUUF9Hqs8lV2zDXzZYIb?usp=sharing
Below screen i would like to see on my visiual tables , i wrote what i want to see near the tables.Could you pls help to create below tables ?
and below screen shows what i was be able to to on my pbix.These are not the tables that i want to see and calculate .
You need to Create a Date Dim table deal with Time Intelligence
Check this file and let me know if this is solivng your problem
https://drive.google.com/open?id=1jRiPpTfXRsIPUyJPc0na0_imE9n5TBqb Down load the pbix from the link
Regards
Vijay Perepa
If this is answer for your question please mention this as answer and share your Kudos
1 Reply
- VijayP
Community Champion
You need to Create a Date Dim table deal with Time Intelligence
Check this file and let me know if this is solivng your problem
https://drive.google.com/open?id=1jRiPpTfXRsIPUyJPc0na0_imE9n5TBqb Down load the pbix from the link
Regards
Vijay Perepa
If this is answer for your question please mention this as answer and share your Kudos