Hi I came across the following calculated column:
Latest OH Test = 'OccupationalHealth'[Test Date] =CALCULATE(MAX('OccupationalHealth'[Test Date]),FILTER(ALL('OccupationalHealth'), 'OccupationalHealth'[COID]=EARLIER('OccupationalHealth'[COID])))
[Test Date] is a date columns. I was surprised to see this column turn to a true/false data type. Is this documented anywhere or a known practice?
note the two equal signs (=) in the formula
Go to Solution.
This is common..It is just comparing a column value with a calculation
You can try this column as well
Calculated Column = 1=1
View solution in original post
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021