Forum Discussion
Calculate function not working
Hello,
I am a beginner in the power BI and need some help. I am trying to calculate number of remaining hours of the project divided by the number of weeks left for the project by project title. I am calculating the remaining time of the project from the project dataset by using today and the last day of the project divindg by 7 to give number of weeks. Then i divide the remaining hours by the remaining number of weeks to get remaining hours /week.
This is working fine at the total project level as i think the total remaining hours and the number of weeks are coming from same table and at the project level
But when i try to get the remaining hours /week by the job title, i get the same answer as the total project level as it it divides the remaining hours for the total project and not for the job title to the weeks remaining. The weeks remaining is contant for the total project and the job titles.
2 Replies
Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
