Power BI Challenge 7 - Purchases, Inventory And Sales!

@Eze You can create active relationships between dates and can also look at @sam.mckay model for reference. I used the lookupvalue function to create additional column in “Received” extracting PO Date from “Purchases”. Then you can calculate the difference between the dates.

OR

You can also look at @BrianJ write up as to how he built his model for this challenge.

2 Likes