Forum Discussion

Sharkybu's avatar
Sharkybu
Icon for Helper II rankHelper II
2 years ago
Solved

Field names from multiple columns containing record

Hello amazing people of the Power Bi forum.   I'm trying to get field names of multiple record column. I'm currently using this formula:   Table.AddColumn(Custom2, current, each let New= try Re...
Need Help
Sharkybu's avatar
Sharkybu
Icon for Helper II rankHelper II
2 years ago

Thank you, it does work.

But I need tocreate a seperate list for each record becase some fields appear in more then one record (like the type field) and when I do list combine I dont know which record has it and which doesn't.

dufoq3's avatar
dufoq3
Icon for Community Champion rankCommunity Champion
2 years ago

Just remove List.Combine and you get separate lists inside a list. If you want to get something else - provide expected result based on my sample data please.

  • Sharkybu's avatar
    Sharkybu
    Icon for Helper II rankHelper II
    2 years ago

    Thank you so much again, you have no idea how much you are helping me.

    I still need to figure out how to separate by the different records. Cause right now when I expand, I get the full list without knowing which field belongs to which record. 

    This is the ultimate end result i'm looking for:

    • dufoq3's avatar
      dufoq3
      Icon for Community Champion rankCommunity Champion
      2 years ago

       

      • Sharkybu's avatar
        Sharkybu
        Icon for Helper II rankHelper II
        2 years ago

        Sorry for the misunderstanding.