Forum Discussion

Thstorm's avatar
Thstorm
Frequent Visitor
7 years ago
Solved

Stuck on DAX formula

Hi All,   I'm stuck on a DAX formula. I have the following table:   _Request_ID LastResponse _Request_Note_ID _Request_Note_ID_Hidden Public_Note_>_7_Days 45342 186 103699 0 0 4...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Thstorm

     

    Seems you missed this parameter only

     

    Public_Note_>_7_Days =
VAR Max_Value =
    CALCULATE (
        MAX ( Query[_Request_Note_ID] ),
        FILTER (
            Query,
            Query[_Request_ID] = EARLIER ( Query[_Request_ID] )
                && [_Request_Note_ID_Hidden] = 0
        )
    )
RETURN
    IF (
        AND ( Query[_Request_Note_ID] = Max_Value, Query[LastResponse ] > 7 ),
        1,
        0
    )
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

Thstorm

 

Seems you missed this parameter only

 

Public_Note_>_7_Days =
VAR Max_Value =
    CALCULATE (
        MAX ( Query[_Request_Note_ID] ),
        FILTER (
            Query,
            Query[_Request_ID] = EARLIER ( Query[_Request_ID] )
                && [_Request_Note_ID_Hidden] = 0
        )
    )
RETURN
    IF (
        AND ( Query[_Request_Note_ID] = Max_Value, Query[LastResponse ] > 7 ),
        1,
        0
    )
Thstorm's avatar
Thstorm
Frequent Visitor
7 years ago

Thats it! Thanks!