Forum Discussion

Jodallen123's avatar
Jodallen123
Icon for Helper I rankHelper I
1 year ago
Solved

Problem with USERELATIONSHIP together with DATESMTD

Hi,   I am trying to create a measure the calculates the running total of a value, if the date is past "today" it should show blank.    My current measure shows a correct running total but I can'...
  • sjoerdvn's avatar
    sjoerdvn
    1 year ago

    Wrap it in an IF, e.g.

    ValueRunningTotal =
IF ( MIN('Master Time Table'[Date]) <= TODAY(),
VAR value=
    CALCULATE (
        SUM ( 'projects'[Value] ),
        'projects'[category] = "Xyz123",
        USERELATIONSHIP ( 'projects'[DoneDate], 'Master Time Table'[Date] ),
        DATESMTD ( 'Master Time Table'[Date] )
    )
 
RETURN
    value
)
sjoerdvn's avatar
sjoerdvn
Icon for Solution Sage rankSolution Sage
1 year ago

Wrap it in an IF, e.g.

ValueRunningTotal =
IF ( MIN('Master Time Table'[Date]) <= TODAY(),
VAR value=
    CALCULATE (
        SUM ( 'projects'[Value] ),
        'projects'[category] = "Xyz123",
        USERELATIONSHIP ( 'projects'[DoneDate], 'Master Time Table'[Date] ),
        DATESMTD ( 'Master Time Table'[Date] )
    )
 
RETURN
    value
)
  • Jodallen123's avatar
    Jodallen123
    Icon for Helper I rankHelper I
    1 year ago

    Big thanks! I did not know you could wrap the whole thing in an IF-statement like that. I only tried to wrap the revenue-variable itself in an IF-statement without any luck.