Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a table or Orders like this:
OrderNumber | InsertionDate | RequiredDeliveryDate | RealDeliveryDate
I would like to create a measure to show, at any time, how many orders are Open (RequiredDeliveryDate in the past and RealDeliveryDate empty or in the future)
Example:
OrderNumber | InsertionDate | RequiredDeliveryDate | RealDeliveryDate
1001 15/05/2020 16/05/2020 11/06/2020
1002 16/06/2020 17/06/2020 22/06/2020
1003 20/06/2020 21/06/2020 05/08/2020
1004 28/06/2020 29/06/2020 06/09/2020
1005 01/07/2020 02/07/2020 27/09/2020
1006 08/07/2020 09/07/2020 08/10/2020
1007 10/07/2020 11/07/2020 04/08/2020
1008 13/07/2020 14/07/2020 24/11/2020
1009 10/08/2020 11/08/2020 05/09/2020
1010 15/08/2020 16/08/2020 18/09/2020
1011 02/09/2020 03/09/2020
1012 04/09/2020 05/09/2020 15/09/2020
1013 09/09/2020 10/09/2020
1014 01/10/2020 02/10/2020
Expected results:
01-jun 01-jul 01-ago 01-sep 01-oct
OPEN ORDERS 1 1 4 5 4
Can you help me?
GREAT!!! Simply perfect.
This solutions really function.
Thank you so much!!!!
Thank you so much for your reply.
I think this is exactly what I want.
Unfortunately I need to build it in Excel/PowerPivot.
I'm afraid it only runs in PowerBI.
Do you know how to adapt this solution to PowerPivot?
Thanks.
User | Count |
---|---|
25 | |
11 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |