Forum Discussion

Pradgouda18's avatar
Pradgouda18
Regular Visitor
2 years ago

Field Parameter to select Columns for analysis

Hi,   I am very new to PowerBI.    I have data in multiple columns (say last 5 year financial data, budgets etc). I need to choose two columns from this and perform analysis (expenses, revenue, p...
Need Help
dufoq3's avatar
dufoq3
Community Champion
2 years ago

Hi Pradgouda18, there are many ways. You can select columns by "parameter" like this for example:

 

Write columns here:

 

Whole sample code.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTICYmMgNlGK1QGKgIXAYmBBmChEGCIOkQDKxAIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t, Column4 = _t]),
    ColumnsParameter = "Column2, Column4",
    SelectedColumns = List.Transform(Text.Split(ColumnsParameter, ","), Text.Trim),
    TableWithSelectedColumns = Table.SelectColumns(Source, SelectedColumns)
in
    TableWithSelectedColumns

 

Pradgouda18's avatar
Pradgouda18
Regular Visitor
2 years ago

Thanks but I am not sure how to use this. I will post my requirements in a separate query