Different Column Results into Rows

Hi,

The trouble is it’s creating 2 separate rows where as I just need the one

For Example this is hows its looking

Thanks

Quick and dirty. Not knowing your datatypes for each object.
I would make the CARALLOWENCEEFFECTIVEDATE a measure, assuming CarAllowance is already a measure. This MAY bring that into a single record for you.

Edit: Welcome to Business Intelligence

thanks for your reply. the object “Salary” and “CarAllowance” 'datatype are measure, “SALARYEFFECTIVEDATE”,“CARALLOWANCEEFFECTIVEDATE” are date. I have already tried your suggestion, but did not work.

Are you able to show us the underlying SQL from your data provider?

I am wondering what the actual data looks like. That would help us determine what is going.

try
max() or first() or last()
on SALARYEFFECTIVEDATE and CARALLOWANCEEFFECTIVEDATE