I am stuck into this I had this table to which I converted to 2nd table below.
|Arun Gopinath Prabhu||27/07/2021||2.5|
|Fahad Rauf Shaikh||28/07/2021||3.6|
|Vikrant Sanjay Tamboli||27/07/2021||1.4|
|Vikrant Sanjay Tamboli||28/07/2021||1.1|
|Arun Gopinath Prabhu||28/07/2021||3.1|
|Shubham A Tembhurnikar||27/07/2021||1.4|
|Shubham A Tembhurnikar||28/07/2021||1.1|
|Fahad Rauf Shaikh||27/07/2021||2.2|
I converted above table to the table below.
|Users||Baseline Hours||Total Hours|
|Arun Gopinath Prabhu||5||5.6|
|Fahad Rauf Shaikh||5||5.8|
|Vikrant Sanjay Tamboli||5||2.5|
|Shubham A Tembhurnikar||5||2.5|
I summed up the hours duration to respective user but now I want to count the number of user based on total hours above 5 so my outcome should be below table showing the count of over achiever which exceeds baseline of 5 hours.
|Users||Baseline Hours||Total Hours||Desired Outcome Count|
|Arun Gopinath Prabhu||5||5.6||1|
|Fahad Rauf Shaikh||5||5.8||1|
|Vikrant Sanjay Tamboli||5||2.5||0|
|Shubham A Tembhurnikar||5||2.5||0|
Solved! Go to Solution.
You can add your desired column to the converted table with this code:
If(table[Total Hours ]>5,1,0)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.