Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
Hi @v-xiandat-msft , 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.
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.
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |