Forum Discussion

oldrunner's avatar
oldrunner
Frequent Visitor
4 years ago

Creating an Index number in DAX

Hi, I need to create a column with index numbers by categories. I have for example 100 different customers and a total of 500 invoices. I need to have a unique index number per customer and invoice....
Need Help
oldrunner's avatar
oldrunner
Frequent Visitor
4 years ago

Thanks,
Rankx replied with an error. I struggle to concat the customer code and sales invoice code to get a unique key.

 

Keith_Fernandes's avatar
Keith_Fernandes
Icon for Advocate II rankAdvocate II
4 years ago

Create a calculated column on your table using concatenate dax function to create a unique key. Also what is the RANKX error you're getting?