Forum Discussion
First Offer Employee
Hi all, I can't solve the following Problem: I have a table with all document position (orders, offers, invoices etc), called BI_Positionen_Doc. It is constructed as following: Article Docum...
Does it have to be DAX or can this be done in Power Query?
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WqqisUtJRyk9LSy0C0oYGRiASiN1T84vSgbSBqZ6BoZ6RgZGRUqxOtFJiUjKGciPcyqGmF6WAlZsaGEBN900sygbrR6iOBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Article = _t, Documenttype = _t, DocumentNo = _t, Position = _t, Salesperson = _t, DocDate = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Article", type text}, {"Documenttype", type text}, {"DocumentNo", Int64.Type}, {"Position", Int64.Type}, {"Salesperson", type text}, {"DocDate", type date}},"de"),
#"Added Custom" = Table.AddColumn(#"Changed Type", "FirstOfferDate", (k)=> Table.Sort(Table.SelectRows(#"Changed Type",each [Article]=k[Article] and [Documenttype]="offer"),{{"DocDate", Order.Ascending}}){0}[DocDate],type date),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "FirstOfferEmployee",(k)=> Table.Sort(Table.SelectRows(#"Changed Type",each [Article]=k[Article] and [Documenttype]="offer"),{{"DocDate", Order.Ascending}}){0}[Salesperson],type text)
in
#"Added Custom1"How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".
Hi Power Query would be also fine. But the code you gave me just gives me the example I posted here as a table? This was only an example...my table BI_Position_Doc has loads of data. I don't know how this formula can help me...
Thanks!