Forum Discussion

AJw1234's avatar
AJw1234
Regular Visitor
2 years ago
Solved

Help comparing last value with current one

I am struggling with what I thought would be a reasonably simple task for .  I have a  basic table which holds details of risks.  Each time the risk is updated the table is updated.  I need to be able to see whether the risk rating is higher or lower than the previous entry

Here is a representation of my table 

TitleCreatedCurRating
TestRisk103/03/2312
TestRisk103/04/2312
TestRisk121/04/2315
TestRisk203/03/236
TestRisk219/03/2312
TestRisk204/05/234
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi AJw1234 ,

    You can create a measure as below to get it:

    Difference = 
VAR _seltitle =
    SELECTEDVALUE ( 'Table'[Title] )
VAR _seldate =
    SELECTEDVALUE ( 'Table'[Created] )
VAR _predate =
    CALCULATE (
        MAX ( 'Table'[Created] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Created] < _seldate )
    )
VAR _prerating =
    CALCULATE (
        SUM ( 'Table'[CurRating] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Created] = _predate )
    )
RETURN
    IF ( ISBLANK ( _prerating ), BLANK (), SUM ( 'Table'[CurRating] ) - _prerating )

    Best Regards

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi AJw1234 ,

    You can create a measure as below to get it:

    Difference = 
VAR _seltitle =
    SELECTEDVALUE ( 'Table'[Title] )
VAR _seldate =
    SELECTEDVALUE ( 'Table'[Created] )
VAR _predate =
    CALCULATE (
        MAX ( 'Table'[Created] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Created] < _seldate )
    )
VAR _prerating =
    CALCULATE (
        SUM ( 'Table'[CurRating] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Created] = _predate )
    )
RETURN
    IF ( ISBLANK ( _prerating ), BLANK (), SUM ( 'Table'[CurRating] ) - _prerating )

    Best Regards

  • AJw1234's avatar
    AJw1234
    Regular Visitor
    2 years ago

    k you so much this is just what I wanted