Forum Discussion

Titatovenaar2's avatar
Titatovenaar2
Icon for Advocate II rankAdvocate II
5 years ago
Solved

DAX: Filter on Multiple Date Columns

Hi there,   I have a table ('Mutations') that has two columns with different dates ('Begindate' and 'Enddate'), and I want to be able to select a period (for instance the month April 2021) and that...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, Titatovenaar2 

    According to your description and sample pbix file, I can roughly understand your requirement, I think you can just use this measure to apply as the visual filter of the table chart:

     

    Flag =

VAR _selectedmonth =

    MONTH ( MAX ( 'Mutations_Period'[StartDate] ) )

RETURN

    IF (

        MONTH ( MAX ( 'Mutations'[StartDate] ) ) = _selectedmonth

            || MONTH ( MAX ( 'Mutations'[EndDate] ) ) = _selectedmonth,

        1,

        0

    )

     

    Then go to the table chart to apply the visual filter like this:

     

    And you can get what you want.

    You can download my test pbix file below

     

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

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

  • Titatovenaar2's avatar
    Titatovenaar2
    Icon for Advocate II rankAdvocate II
    5 years ago

    Thanks for this blog post, it's quite interesting, but I have to say that I can't easily grasp why they make the choices they do. I am experimenting with it now, but not so lucky yet.

     

    Meanwhile, this is the file in which I have it all. Basically If I select 'April', I want 'April' from both column 'StartDate' and 'EndDate'.

     

    MultipleDataFilter.pbix