Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |