Power query | parameter query to filter data a predefined list from google bigquery database

[nikahafiz]

hi,

i hv also received the solution to an almost similar problem via

Power query | parameter query to filter data by dates (year) from google bigquery database

hi, i get my data for period beginning 01 January 2015 from google bigquery as follows: Source = Value.NativeQuery(GoogleBigQuery.Database() {[Name=“abc-stock”]}[Data], “select * from abc-stock.uk.uk where (ORIGIN=‘LAX’ or DEST=‘LAX’)”, null, [EnableFolding=true]) note: i have filtered the output for ORIGIN or DEST to be ‘LAX’. the data only date value is in the column DATE. i’d like to create a parameter query that allows me to filter data for following condition examples: year is…

tks, -nik