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

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Anonymous

 

Sorry I thought its a Meausre.

 

What are you tyring to acheive?

 

Your formula looks good

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