Loading Distinct records

[Anonymous]

Dear all,

How to perform Distinct to this formula

Key = CONCATENATE(Bounce[Account No ],FORMAT(Bounce[MonthYr],"DD-MM-YYYY"))

[Zubair_Muhammad]

@Anonymous

May be

Key =
CONCATENATE (
    VALUES ( Bounce[Account No ] ),
    FORMAT ( VALUES ( Bounce[MonthYr] ), "DD-MM-YYYY" )
)

[Anonymous]

Dear Zubair,

Thanks for ur reply.

I am getting an error 

[Zubair_Muhammad]

@Anonymous

Sorry I thought its a Meausre.

What are you tyring to acheive?

Your formula looks good

[Anonymous]

Dear Zubair,

i am concatenating two columns into one.In that i want distinct.

[Anonymous · Accepted solution]

@Anonymous,

Please use the following DAX.

Key = Bounce[AccountNo] & FORMAT (Bounce[MonthYr] , "DD-MM-YYYY" )

Regards,
Lydia