Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Check if previous value is the same or different - Comparing data across dates

Hi. I have a data feed of hardware used within a company that is reviewed every morning. The goal of the DAX is to check if the hardware on a particular node has changed, and the equation below doe...
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    Please check it this is the output that you're looking for:


    The Measure I'm using is this:

    New Hardware Swap = 
    VAR _SerialNumber = SELECTEDVALUE(FieldReplaceableUnit_productData[f_serialNumber])
    VAR _MaxDate = 
        CALCULATE(
                MAX(FieldReplaceableUnit_productData[Date created]),
                FILTER(
                    //ALL(FieldReplaceableUnit_productData),
                    ALLEXCEPT(FieldReplaceableUnit_productData, FieldReplaceableUnit_productData[f_managedElementId], FieldReplaceableUnit_productData[f_fieldReplaceableUnitId]),
                    FieldReplaceableUnit_productData[Date created] < MIN(FieldReplaceableUnit_productData[Date created])
                )
        )
    
    VAR _Calculation = 
        CALCULATE(
            VALUES(FieldReplaceableUnit_productData[f_serialNumber]),
            FILTER(
                ALL(FieldReplaceableUnit_productData),
                FieldReplaceableUnit_productData[Date created] = _MaxDate && (FieldReplaceableUnit_productData[f_managedElementId] = SELECTEDVALUE(FieldReplaceableUnit_productData[f_managedElementId]) && FieldReplaceableUnit_productData[f_fieldReplaceableUnitId] = SELECTEDVALUE(FieldReplaceableUnit_productData[f_fieldReplaceableUnitId]))
                )
            )
    VAR _Result = _Calculation
    
    RETURN
        IF( ISBLANK(_Calculation), 0,
            IF(_SerialNumber = _Calculation,0,1)
        )