Forum Discussion

STEVE_WT's avatar
STEVE_WT
Frequent Visitor
1 year ago
Solved

Custom column to filter a date table dynamically

Hi   I have a list of campaign which a user will choose from a drop down slicer. Each of these campaigns has a start and end date.  I also have a standalone calendar table with a list of dates. I ...
Need Help
  • STEVE_WT's avatar
    STEVE_WT
    1 year ago

    This worked perfectly. It was causing a lot of stress! Thanks very much for helping.

     

     

johnt75's avatar
johnt75
Super User
1 year ago

I'd create a calculation group with a calculation item like

Calc item =
IF (
    HASONEVALUE ( 'Table'[campaign name] ),
    CALCULATE (
        SELECTEDMEASURE (),
        DATESBETWEEN (
            'Date'[Date],
            SELECTEDVALUE ( 'Table'[start date] ),
            SELECTEDVALUE ( 'Table'[end date] )
        )
    ),
    SELECTEDMEASURE ()
)