PowerBI Report Builder filter expression "EndOfYear"/"StartOfYear"

[IlMoro]

Hi,

I have a report that I succeeded in filtering based on a date column that has a date older than 5 years from today:

The expression inside "Value" is:

=DateAdd(DateInterval.Year, -5, NOW())

I need now to define in the expression, instead of today date, the end of the actual year (and even, in onother filter, the start of the actual year.

Thanks for any help.

[IlMoro]

Hi @Anonymous , it is not clear for me what I have to do.

I have just a dataset containing assets details and a column that contains the purchase date (dd/mm/yyyy).

I need to filter the dataset so it show just those assets having a purchase date that is 5 years old from the end of the current year.

[Anonymous · Accepted solution]

Hi @IlMoro ,

Below is my table:

The following Expression might work for you:

DateDiff("yyyy",Format(Fields!Date.Value,"Long Date"),Now())

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.