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 tables along with certain selection processes. Thanks.

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

3 Replies

  • 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! 

       

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Icon for Community Support rankCommunity Support
    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