Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!!!
@AAMARILLO , Refer to my blog it deals with dates and open between those
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |