Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Including a date filter within a measure

Hello,   I am trying to use a date filter within a measure. My measure needs to only return data from September 2020 or later. I cannot use a slicer as my measure is drawing data from multiple tabl...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi, Anonymous 

     

    Change the date as you need, like this

    from September = 
CALCULATE(
    [myMeasure],
    FILTER(
        'Table',
        'Table'[Date]>=DATE(2020,9,1)&&'Table'[Date]<=TODAY()
    )
)

     result:

    If this doesn't work for you, then please consdier sharing more details about it or a simple sample file without any sesentive information so that i may work out with a workaround.

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Anonymous ,

 

you can set the filter in your table to September:

September Values =
CALCULATE(
    [myMeasure],
    MONTH( DateTable[Date] ) = 9
)

 

Or if the measure should only return values if the filter context is September then use the FILTER function:

September Values =
CALCULATE(
    [myMeasure],
    FILTER(
        DateTable,
        MONTH( DateTable[Date] ) = 9
    )
)

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for response. I believe you are right and this is what I'm looking for, however I need values from September until today. How would I write "since 9.2020", not just = 9. Thanks!