Forum Discussion
If statmement in Mquery
let
Source = #"Parent Element (2)",
#"Removed Columns" = Table.RemoveColumns(Source,{"Parent Webid", "Child Element Webid"}),
#"Expanded Data" = Table.ExpandRecordColumn(#"Removed Columns", "Data", {"Items"}, {"Items"}),
#"Expanded Items" = Table.ExpandListColumn(#"Expanded Data", "Items"),
#"Expanded Items1" = Table.ExpandRecordColumn(#"Expanded Items", "Items", {"Name", "Items"}, {"Name", "Items.1"}),
#"Expanded Items.1" = Table.ExpandListColumn(#"Expanded Items1", "Items.1"),
#"Expanded Items.2" = Table.ExpandRecordColumn(#"Expanded Items.1", "Items.1", {"Timestamp", "Value"}, {"Timestamp", "Value"}),
#"Expanded Items x" = Table.ExpandRecordColumn(#"Expanded Items", "Items", {"Name", "Value"}, {"Attribute", "Value"}),
#"Expanded Value" = Table.ExpandRecordColumn(#"Expanded Items x", "Value", {"Timestamp", "Value"}, {"Timestamp", "Value"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Value",{{"Timestamp", type datetimezone}}),
GetResult = IF parameter = "recorded" then #"Expanded Items.2" else #"Changed Type"
in
GetResult