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
Margreet
Helper II
Helper II

count active nr fron Def Startdate to Def enddate

Margreet_0-1679129015530.png

 

1 ACCEPTED SOLUTION

@Margreet 

You can use the same formula only replace [Stardate] with [Def Startdate] and [Enddate] with [Def Enddate] 

View solution in original post

4 REPLIES 4
Margreet
Helper II
Helper II

Margreet_1-1679168758914.png

@tamerj1 

 

@Margreet 

You can use the same formula only replace [Stardate] with [Def Startdate] and [Enddate] with [Def Enddate] 

tamerj1
Super User
Super User

Hi @Margreet 

despite the 2nd SUMMARIZE is not required, this dax code should work. What exactly is the problem that you are facing?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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