Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Selection for date value based on multiple date column criteria

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

 

 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ，

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ，

    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