Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I did this before and now completely forgot what I did.
I have a colum called "NTE Hours" and a column "Duration" as well as a column "NonRecurringServicesTotal Actual" which is a dollar amount. The relationship is attached to a job number, multiple job reports are summed together to create "duration" where there is only one NTE Hours value per job number.
I need to calculate theprojected hourly rate as well as the actual hourly rate
Projected= NonRecurringServicesTotal Actual/ NTE Hours
Actual= NonRecurringServicesTotal Actual/ Duration
Any assistance on how to write this out is appreciated
Solved! Go to Solution.
Regarding how to wirte the formula depends on where you would like to use the result.
For example, if you would like to add the calculated results into the current table, we could write the formula in the following format:
As a calculated column:
Projected = DIVIDE(Table1[NonRecurringServicesTotal Actual], Table1[NTEhours])
ActualRate = DIVIDE(Table1[NonRecurringServicesTotal Actual], Table1[Durations])
See if this would help, and if any further help needed, please post back.
Regards,
Charlie Liao
Regarding how to wirte the formula depends on where you would like to use the result.
For example, if you would like to add the calculated results into the current table, we could write the formula in the following format:
As a calculated column:
Projected = DIVIDE(Table1[NonRecurringServicesTotal Actual], Table1[NTEhours])
ActualRate = DIVIDE(Table1[NonRecurringServicesTotal Actual], Table1[Durations])
See if this would help, and if any further help needed, please post back.
Regards,
Charlie Liao
Probably create a couple measures like:
Projected = SUM([NonRecurringServicesTotal Actual])/SUM([NTE Hours]) Actual = SUM([NonRecurringServicesTotal Actual])/SUM([Duration])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |