Forum Discussion
Solved
New column - value depends on another column
Hi, I can't figure this one out. I want to add a column to this table which equals: 120/Number of times a 'Staff Num' occurs in the 'Staff Number' Column. So if 49974 occured 60 times in S...
the number is still about 100 times higher than the number i am looking for.
That's ok, i'll just use constant lines.
cheers
Could this be the tweak?
New Column =
VAR StaffCol = 'Table1'[StaffNum]
VAR X = CALCULATE(COUNTROWS('Table1'),
FILTER(
'Table1',
'Table1'[StaffNum] = StaffCol && 'Table1'[Detail] = "Sick"
)
)
VAR Y = 120
RETURN DIVIDE(x,y)
the number is still about 100 times higher than the number i am looking for.
That's ok, i'll just use constant lines.
cheers