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
Keith_Fernandes's avatar
Keith_Fernandes
Icon for Advocate II rankAdvocate II
4 years ago

Try to concat customer_code and Sales_invoice_code to generate a unique key. You can then create an index on this. You can also use RANKX function to get unique count against each value. Try these workarounds.