Forum Discussion
DAX Calculated Column Boolean Field - Double Amount Of Rows Expected Issue In Output Results
I would like a calculated Field to produce the "Type" field below in this context. Date Val1 Val2 Abs Value Diff Type 1/1/2018 5 4 1 Mismatch 1/2/2018 5 5 0 Match 1/3/20...
Use the function ABS() to get the absolute difference.
Abs Value Diff = ABS(Value1 - Value2)