Calculated Column

[Rajni264]

I am having a table having column name "Name", "Date", 'Clocked Hours", "Mandatory Hours". For the same date and Name, I have different clocked hours. However for the "Mandatory hours", I only want 8 in one of the cells for the same date and Name and make other cell value 0 for the same Date and Name. How to achieve this by creating New Calculated. (After I am able to solve the iissue with one employee, I will implement the solution for more than 50 different Name and Date range is from 1 January 2023 onwards)

column.

[Rajni264]

@Greg_Deckler Thanks for quick response. it seems that the solution given by you is working .

[Greg_Deckler · Accepted solution]

@Rajni264 Add an Index column in Power Query Editor and then this as a calculated column (DAX):

Mandatory Hours Column =
  VAR __Index = [Index]
  VAR __Name = [Name]
  VAR __Date = [Date]
  VAR __MinIndex = MINX(FILTER(ALL('Table'), [Name] = __Name && [Date] = __Date), [Index])
  VAR __Result = IF(__Index = __MinIndex, 8, 0)
RETURN
  __Result