Forum Discussion

lutre's avatar
lutre
New Member
8 years ago

Transform Table and Filtering [Beginner]

Hey,   I´m new to Power BI so sorry for this basic question.   "VarName";"TimeString";"VarValue";"Validity";"Time_ms" "Auftrag";"15.05.2018 09:56:25";0;1;43235414182,9977 "Auftrag h";"15.05.2018 ...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi lutre,

you can Pivot your VarName column in Query Editor, and select VarValue as your values column

let
    Source = Csv.Document(File.Contents("C:\Downloads\Data.csv"),[Delimiter=";", Columns=5, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"VarName", type text}, {"TimeString", type text}, {"VarValue", Int64.Type}, {"Validity", Int64.Type}, {"Time_ms", type number}}),
    #"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[VarName]), "VarName", "VarValue", List.Sum)
in
    #"Pivoted Column"