Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
AAMARILLO
Regular Visitor

Count lines with Date as a variable

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?

3 REPLIES 3
AAMARILLO
Regular Visitor

GREAT!!! Simply perfect.

This solutions really function.

Thank you so much!!!!

 

amitchandak
Super User
Super User

@AAMARILLO , Refer to my blog it deals with dates and open between those

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.