Forum Discussion

ulyssus's avatar
ulyssus
Regular Visitor
3 years ago

Help - lookup value

Hi All,    I am new to power bi and couldn't figure this query out. I have a table like below with the list of work email based on the source.  Name Work email Source Dave [email protected] A ...
Need Help
wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

not really get your point, just try to transform the format

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WckksS1XSUUp0SExK1kvOzwWyHZVidaKVnFJzcoCcJCQJZ7BEeEZmCUhLMpKMk1JsLAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t, #"Work email" = _t, Source = _t]),
    Custom1 = Table.FromRecords(Table.TransformRows(Source,each Record.AddField([[Name]],[Source],[Work email])),{"Name"}&List.Distinct(Source[Source]),2)
in
    Custom1