if a number is in one of the two columns that then return that numer.

[Anonymous]

 I want a DAX formula that returns if the Results. It should look in A or B and pull the number as the results for the product. If there is a blank then there were no test results for that test and only return the row that has a number in it.  Thanks.

[Anonymous]

Hi @Anonymous,

If you can confirm these fields only exist one value, you can try to create a calculated column with aggregate function to return the correct one.

Result = MAX('Table'[ResultA],'Table'[ResultB])

Regards,

Xiaoxin Sheng

[Pragati11 · Accepted solution]

Hi @Anonymous ,

You can try creating a calculated column as follows:

I am assuming there will never be a scenario where Result A and Result B will both have Non Blank values.

Results = IF([ResultA] <> BLANK(), [ResultA], IF([ResultB] <> BLANK(), [ResultB], BLANK()))

Let me knnow if this works or I have taken a wrong assumption.

Thanks,

Pragati