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

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