First 20 days of the current month data

[power_user_123]

Hello,

In my table visual, I have a date column "DATE_ADD". I want to apply filter for this visual to show data for the first 20 days of the current month. Any tips to acheive this? 

Thanks

[v-zhangti · Accepted solution]

Hi, @power_user_123 

You can try the following methods.

Measure =
IF (
    MONTH ( SELECTEDVALUE ( 'Table'[Date] ) ) = MONTH ( TODAY () )
        && DAY ( SELECTEDVALUE ( 'Table'[Date] ) ) <= 20,
    1,
    0
)

Put Measure in the view's Filter and set it equal to 1.

           

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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