Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Loading Distinct records

Dear all,   How to perform Distinct to this formula Key = CONCATENATE(Bounce[Account No ],FORMAT(Bounce[MonthYr],"DD-MM-YYYY"))
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    Please use the following DAX.

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



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Dear Zubair,

 

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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

Please use the following DAX.

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



Regards,
Lydia