Filter On Last 3 days of every month

[Shambhavi]

Here I want to add a filter such that for any date range that I select, it should show data only for the last 3 days of every month.

[prantika_sinha]

Hi @Shambhavi ,

For this use case, I would create a calculated field to determine if the date falls under last three days of the month then return yes else no. Use the same field in the visual and set the filter to yes.

And for the field, I would use dateDiff to check number of days between deactivation date and first date of next month from deactivation date

1. use dateAdd to add a month to the deactivation date
2. truncdate to return the starting of the month for the next month
3. dateDiff to find days between deactivation date and date from step 2.

This would give me the days difference and we can use this field to check if the value is less than equal to 3.

Thanks,
Prantika