cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Help with Contract burn - mutiple contracts with start and end dates

I have a project where I have to calculate the burn rate based on labor ceiling for contracts per month based on the fee charged that month.

I have set up the calendar and labor ceiling tables and getting the payment date and amount charged. I am able to calulate the running totals but have an issue from when it starts counting down the contract since it is pulling data for prior contracts.

How do I make sure to only calculate down from the start date (month and year) for the projects. It is also summing the prior project ceilings together.

7 REPLIES 7
Super User IV
Super User IV

@PBIUser25 , refer if this can help

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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

@amitchandak I am new to Power BI and not sure your post helps in my case since it is only calculating the number of employees in a previous and given month. It would be more relavant with total salary for the year and then amount paid each month and counting down to calculate the burn report. 

Community Support
Community Support

Hi @PBIUser25 ,

 

You may create measure like DAX below .

 

 

Cumulative total Per Year =
CALCULATE (
    SUM ( Table1[Amount] ),
    FILTER (
        'labor ceiling',
        'labor ceiling'[contracts] = MAX ( 'labor ceiling'[contracts] )
            && YEAR ( 'labor ceiling'[Date] ) = YEAR ( MAX ( 'labor ceiling'[Date] ) )
            && MONTH ( 'labor ceiling'[Date] ) <= MONTH ( MAX ( 'labor ceiling'[Date] ) )
    )
)

 

 

If I misunderstood it, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

 

Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

 @v-xicai Thank you so much Amy! I am trying to figure out how to attach the file. I don't see an option to just upload any file.

Hi @PBIUser25 ,

 

You can also upload sample pbix to OneDrive (you can find it in following location) and post the link here. Do mask sensitive data before uploading.

Onedrive.png

 

 

 

 

 

 

 

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

@v-xicai  Here is the link for onedrive: https://1drv.ms/u/s!AmJqEyBIpAulgixt_wHZNaxL4Ofm 

@v-xicai were you able to get to my file on onedrive? Posted again just in case.

https://1drv.ms/u/s!AmJqEyBIpAulgixt_wHZNaxL4Ofm 

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors