Forum Discussion

Faranak_Zagia's avatar
Faranak_Zagia
Advocate I
1 year ago
Solved

Product IDs

Hi everyone, I am new to Power BI and I have a table with 4 columns, each containing product IDs. How can I extract all unique product IDs from these columns into one list? Column 1 (Product IDs)...
Need Help
  • Ahmedx's avatar
    Ahmedx
    1 year ago

    pls try this

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("NY2xDQAwCMN+Ye4ASQ/pjvj/jVakTFZkS8m04x62HsIbEOhWqy1kFUFgjKWsIgjE2N37H0AtaVUX", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t, Column4 = _t]),
    Custom1 = List.Union( Table.ToColumns( Source))
in
    Custom1
  • Omid_Motamedise's avatar
    Omid_Motamedise
    1 year ago

    Consider your table as a Source, then use the next formula.

     

    List.Union(Table.ToRows(Source))

Omid_Motamedise's avatar
Omid_Motamedise
Super User
1 year ago

Consider your table as a Source, then use the next formula.

 

List.Union(Table.ToRows(Source))