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

5 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Anonymous

     

    May be

     

    Key =
CONCATENATE (
    VALUES ( Bounce[Account No ] ),
    FORMAT ( VALUES ( Bounce[MonthYr] ), "DD-MM-YYYY" )
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Dear Zubair,

       

      Thanks for ur reply.

       

      I am getting an error 

       

      • 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