Selection for date value based on multiple date column criteria

[NISHA_S]

I have a report showing table data based on  a date selecting from a calender date value.

The issue am facing is while selecting a calender  date column from slicer based on that table data need to apply one criteria which is 

if user is selecting date 09-08-2023,

 report will show based on below condition

created_date >=01-08-2023 and Created_date<31-08-202 and Expiry date <=09-08-2024

[v-yiruan-msft · Accepted solution]

Hi @NISHA_S ，

I created a sample pbix file(see the attachment), please check if that is what you want.

1. Create a measure as below

Flag = 
VAR _seldate =
    SELECTEDVALUE ( 'Calendar'[Date] )
VAR _selcdate =
    SELECTEDVALUE ( 'Table'[Created date] )
VAR _seledate =
    SELECTEDVALUE ( 'Table'[Expiry date] )
RETURN
    IF (
        _selcdate >= DATE ( YEAR ( _seldate ), MONTH ( _seldate ), 1 )
            && _selcdate < EOMONTH ( _seldate, 0 )
            && _seledate <= _seldate,
        1,
        0
    )

2. Create a table visual and apply the filter with the condition (Flag is 1)

Best Regards