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

Power Query
1

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:

  1. year is > 2017

  2. year is between 2015 and 2018

i’d appreciate any help to show me how to parameter query to filter for those condition.

tks & krgds, -nik

p.s.

separately, i have seen how power query in ms excel uses parameter table but i’m not sure if such method is available in ms power bi too.

2

Bumping this post for more visibility from our experts and users.

3

Hi @nikahafiz - There are multiple posts available online that covers this topic.
Idea will be to create these Parameters inside Power BI and pass them to your SQL Query to filter data dynamically.

Please refer

Thanks
Ankit J

4

tks, @ankit.

let me study this deeper for a better understanding & implementation.

if all goes well, i’ll revert to close this case too (@EnterpriseDNA).

krgds, -nik