Forum Discussion
Need help with functions / parameters
Thanks for reply!
Actually I'm combining more than 2 tables...
Currently data structure is 1 day => one folder with one table in it.
Data is stored in Azure datalake and this data structure was chosen in order to have flexibility with quering different periods of time.
I can query for a single day(1 table), for 1 month(28-31 tables), of for a year... long periods require very long query text in advanced query editor.
Way of quering is not elegant, but I have not found a way how to query for specific period in datalake.
Therefore I thought there could be an option to use parameters with functin and make automatic query for required period(tables).
If you know how to make query for a specific period(raws) in datalake, I could rebuild data and use only 1 table and then query for specific rows(starting date, ened date)
BR
Pavel
Have you thought about introducing a DATE table https://www.agilebi.com.au/blog/power-bi-date-dimension (related to your source tables model) ? You could do that and then use a slicer (with data field) in Power BI report view to return customer periods data. There is not need to build this logic in Power Query.
N-