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

project value distributed over upcoming months

Tables:

Duration (duration refers to months here)

DepartmentDuration
Dep11,5
Dep22


Project

IDNameDepartmentStartDateValue
1Project1Dep104-10-202150.000
2Project2Dep204-10-202140.000


My goal is to visualize the project values for the upcoming months. There are two solutions, both would be of interest:

  1. For example, disregarding that StartDate is a date and threating it only on monthly level. So that Project ID 1's value would be split between October (33.333) and November (16.667).

  2. Treat StartDate as a Date, and factor in the remaining days or workdays of the month.
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@akos_skutovics , refer if the attached file or two blogs can help

 

How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

 

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

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@akos_skutovics , refer if the attached file or two blogs can help

 

How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

 

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.