Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Is it possible to create a unique identifier based on the contents of two columns?

I need to create a unique identifier column for a list of surveys submitted, and I want the surveys submitted for the same category to be given the same ID. Is this possible in Power BI?    Here's ...
Need Help
  • jthomson's avatar
    jthomson
    8 years ago

    Would this not just be the same as duplicating your table, removing everything but the survey column, removing duplicates then adding an index column?

augustodarruda's avatar
augustodarruda
Frequent Visitor
5 years ago

Hey, thanks a lot, you helped me a lot, but I am struggling with something here, and perhaps you may help me.

I am using 6 columns to make one that is unique. But what happens is that some of these fields have 'null' values, and when I conatenate the text, the result ends up bein 'null', and I don't want that.

Is there a way to ignore if the cell is null and just add the text?

Thanks in advance