Merge 2 sets of data elements then subtract

Hi  jonnyA ,

According to the prompt error:

It is found that it is a data type problem, you can check whether [Procedure_Code] is of Text type.

If it is of Text type, you can modify Admit Date and Discharge Dates to the following:

Admit Date =
CALCULATE(MAX('Table'[DOS]),FILTER(ALL('Table'),'Table'[Procedure_Code] in {"99221","99222","99223"}&&'Table'[Patient_First_Name]=MAX('Table'[Patient_First_Name])))

Discharge Dates =
CALCULATE(MAX('Table'[DOS]),FILTER(ALL('Table'),'Table'[Procedure_Code] in {"99238","99239"}&&'Table'[Patient_First_Name]=MAX('Table'[Patient_First_Name])))

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi  jonnyA ,

This is the same as above, it is a text type, you can change the function.

{99221,99222,99223}To {"99221","99222","99223"}

{99238,99239} changed to {"99238","99239"}

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.