Table Criteria to show current Year

[djennings (dean)]

HI All

Have a labor BAQ which gives me whats gone on in the day this gets exported into a Power BI dashboard, which is great however i get all the data when i just want to have the current yeah so 2024. I have 2 date fields clock in and clock out which i was hoping to use to filter to current year.

Any ideas on how to filter this to make sync with Power BI faster.

Cheers for any help

[hackaphreaka (Garret Travers)]

There are probably a lot of ways to do this but you could first add a calculated field to your query that returns the year from ClockInDate:

There is also a BAQ constant that returns the current year, so you can then add a Subquery Criteria that compares the value of your calculated field to the constant value and return rows where they match: