Forum Discussion

tomasrcm's avatar
tomasrcm
New Member
2 years ago

Help calculating purchasing requisitions backlog per month

Hi! I need help to calculate a monthly indicator related to open purchasing requisitions backlog for each month. Today, when a Purchasing requisition does not have a Purchase Order, we consider it in...
Need Help
tomasrcm's avatar
tomasrcm
New Member
2 years ago

thanks Anonymous! My main problem is that the requsitions will change status over time. For example, by end of May PR 1003 could be open and will be shown in the indicator as open, but if during June is closed I will not be able to know how many open PRs I had by end of May because the indicator will change. 

 

I will need like a "snapshot" of end of may to compare it with the end of june indicator

 

thanks for the response!

I have attached the complete table I am using in case it provides more clarity.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, tomasrcm 

Thank you very much for your reply. After you import the data into Power BI, you can display and process the imported data, but Power BI does not have a data snapshot function like a database, it is a report display software. I think the best way to do this is to save your data for different months as different files and then import it into Power BI and then go through the previous DAX expression, calculate the difference so that you can understand how each month compares.

 

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.