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

 

May be

 

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