cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

calculated column with 2 equal sign (no var involved) - is this accepted practice?

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

 

thank you

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User I
Super User I

Hi @Anonymous

 

This is common..It is just comparing a column value with a calculation

 

You can try this column as well

 

Calculated Column = 1=1
Regards,
Zubair


View solution in original post

2 REPLIES 2
Highlighted
Super User I
Super User I

Hi @Anonymous

 

This is common..It is just comparing a column value with a calculation

 

You can try this column as well

 

Calculated Column = 1=1
Regards,
Zubair


View solution in original post

Highlighted
Anonymous
Not applicable

thank you!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors