Forum Discussion

monicajsv's avatar
monicajsv
Frequent Visitor
2 years ago

Relative date filtering

I have a list of elements with a planned end date and I would like to do a relative filtering of the date in the visualization to only show those whose end date is greater than or equal to 6 months a...
Need Help
Show and Tell
Tips and Tricks
some_bih's avatar
some_bih
Community Champion
2 years ago

Hi monicajsv possible solution as following

If you need measure then it could be like:

Measure test=
CALCULATE (

SUM(Yourtable[somecolumn]),

DATESINPERIOD (
        'Date'[Date],           -- Your Date key column
        TODAY(),                -- Today
        -6,                      -- the set needs to contain 6
        MONTH                   -- months
    )
)
 
DAX function DATESINPERIOD

https://learn.microsoft.com/en-us/dax/datesinperiod-function-dax?WT.mc_id=DP-MVP-4025372

 

Did I answer your question? Kudos appreciated / accept solution!

 

monicajsv's avatar
monicajsv
Frequent Visitor
2 years ago

Hello,

I don't need a measure, I just want to be able to filter them.

Thanks for your help, I think I'll use a colum to calculate if the date is within the relative period I need and the use this column to filter.

Regards,

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    HI monicajsv,

    Maybe you can try to add a calculated column to compare with current date and table date to map records with period tags. Then you can use this field on filter to filter your visual records based on period tags.

    Regards,

    Xiaoxin Sheng