Run Query base on a current Week

[Rigolleto]

Hi,

I am bulding a dashboard and it has being populated daily, this is a weekly analysis data, since I need to load the current week data and the system is showing me the whole weeks then I need to find the best way to calcule the current week and send it to the query and resolve and/or get the current data week, just it should be unattended process, every time the dashboard has being refreshed then get the data.

For instance

Current week 14

The query should check for the current week and then send it as a parameter to the power qry

Any one can help me and/or tell me the best way to achive this

Thanks

Rigo

[parry2k · Accepted solution]

@Rigolleto what is your data source? Instead of filtering by query, you can always use relative date filtering, read more here .