Forum Discussion

ahmedKalbani's avatar
ahmedKalbani
Frequent Visitor
7 years ago
Solved

Adding an identifier column

All,

 

I am cleaning the data set in power BI. I' have this table in power BI and I want to add a column identifier for the datasets (Identifer column) using Task and Content columns logic. any useful condition I can use?

Thank you in Advance.

AK

Tips and Tricks

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    Will you actually have text 2.1, text 2.2 etc. in the second column are are they just dummy entries?

    • ahmedKalbani's avatar
      ahmedKalbani
      Frequent Visitor
      7 years ago

      These are examples. The original file (excel) source format was the following:

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Hi,

         

        Download my PBI file from here.

         

        Hope this helps.