Calculated Fields in a matrix

[Anonymous]

Hi,

I have a matrix that pulls through the below information:

I need to add some calulated fields onto the matrix based on the data it has grouped already. 

Below is an example of the columns needed to be added on shown in red:

Can anyone advise the best wy to perform these calculations based on a matrix or an alternative way to achieve what i am trying to do?

Many thanks,

Phil

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

If the columns in the matrix is the separate column in the original table. There is a way using calculated columns to implement. If not, please post the simulated original table.

Create the calculated columns

Used Time = Table1[Absence]+Table1[Billable Time]+Table1[Non Billable Time]+Table1[Pitch Time]+Table1[Internal Time]

Max Billable Hours = Table1[Used Time] / Table1[Absence]

Available Hours = Table1[Basic Time] - Table1[Absence]

Best Regards,

Xue Ding

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