Forum Discussion

Dsch1971's avatar
Dsch1971
Frequent Visitor
3 years ago
Solved

Filter a measure until today

Hi   I have the following measure in a line chart but wnat the line to stop as of today.   This is my measure.   How can i achieve this please?    Total Wins FY 22 running total in MonthShor...
  • djurecic's avatar
    djurecic
    3 years ago

    Hi Dsch1971 ,

     There are several ways to do this. Here is one option.

     

    Create a calculated column in your date table Is Before Today.

     

    Something like this:

    IsBeforeToday =
    var currentrowdate= Dates[Date]
    var today = TODAY()
    RETURN
    IF(currentrowdate < today,TRUE(),FALSE())
     
    Then use that calcualted column as a filter for your visual like below:
djurecic's avatar
djurecic
Icon for Super User rankSuper User
3 years ago

Hi Dsch1971 ,

 There are several ways to do this. Here is one option.

 

Create a calculated column in your date table Is Before Today.

 

Something like this:

IsBeforeToday =
var currentrowdate= Dates[Date]
var today = TODAY()
RETURN
IF(currentrowdate < today,TRUE(),FALSE())
 
Then use that calcualted column as a filter for your visual like below: