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
Syndicate_Admin
Administrator
Administrator

Multiple dates

Good afternoon

I'm new and I have a problem that I can't solve:

I have a table of facility data, in which I have the start, end and service days dates for each installation (assemblies). I want to count the services per day, but since the duration of the installation is >1 day, it no longer tells me that the next day that installer is busy, because it counts only the dates that appear in the table.

Something like that

Servicestart datedays of serviceend date
A29/03/2021230/03/2021
B29/03/2021331/03/2021
C30/03/2021301/04/2021
D30/03/2021231/03/2021
E30/03/2021402/04/2021
F30/03/2021130/03/2021
G31/03/2021201/04/2021
H01/04/2021202/04/2021
I02/04/2021304/04/2021
J03/04/2021103/04/2021

On the 31st/03rd I would have to show up that I have 5 installations in progress, but only counts 1, for its start date.

In excel is very simple, I make a macro that inserts me an extra row with the same data but changing the service date and ready, but the data automatically reaches me power bi and I didn't want to have to go through excel.

Could someone help me?

A greeting and thank you very much in advance

1 ACCEPTED SOLUTION
v-deddai1-msft
Community Support
Community Support

Hi @Syndicate_Admin ,

 

You can create a dim_date table for slicer:

 

Dim_Date = CALENDARAUTO()

 

Then use the following  measure to  show up installations in progress:

service in progress = CALCULATE(COUNT('Table'[Service]),FILTER('Table','Table'[start date]<=SELECTEDVALUE(Dim_Date[Date])&&'Table'[end date]>=SELECTEDVALUE(Dim_Date[Date])))

 

Capture1.PNG

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

 

 

View solution in original post

4 REPLIES 4
v-deddai1-msft
Community Support
Community Support

Hi @Syndicate_Admin ,

 

You can create a dim_date table for slicer:

 

Dim_Date = CALENDARAUTO()

 

Then use the following  measure to  show up installations in progress:

service in progress = CALCULATE(COUNT('Table'[Service]),FILTER('Table','Table'[start date]<=SELECTEDVALUE(Dim_Date[Date])&&'Table'[end date]>=SELECTEDVALUE(Dim_Date[Date])))

 

Capture1.PNG

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

 

 

Thanks a lot! This is extremely what I needed!

It's perfect!

Syndicate_Admin
Administrator
Administrator

amitchandak
Super User
Super User

@Syndicate_Admin , Check if my HR blog on similar topics of two dates can help

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

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.