Forum Discussion
Week filter - Pick Up week vs Delivery week
Hi,
I want to build a single filter that can provide me with the same weeks for both pick up and delivery. As some deliveries made in a week can be picked up in another, the data will not be correct for pick ups if i e.g. filter on delivery week 27 as the pick up could have been in week 26.
So, I want to be able to look at ranges, e.g. w23-26, where I can have pick ups on one page and deliveries on another. Then I want to be able to see absolute number of pick ups per week and absolute number of deliveries.
Thanks.
2 Replies
Anonymous , to check what picked in the week and what delivery happened in a week. Here pick may happen before this week and delivery for pickup happen after this week.
In such case, you can use a single date table and use userelation . Refer
for week calendar
WTD Questions— Time Intelligence 4–5
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123In case you need to analyze them differently then use two calendars joined with each date.
Also, refer to cohort
https://finance-bi.com/power-bi-cohort-analysis/
http://funbiworld.com/2019-12-02-cohort-analysis/
https://www.youtube.com/watch?v=tuk1CrigTSIHi Anonymous ，
Based on my understanding ,you should first create a separate slicer table with all the available weeks;
Then create 2 measures,1 returns the pick ups during the selected range of weeks while another returns deliveries.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
