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...
Need Help
  • _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)
    )
_AAndrade's avatar
_AAndrade
Resident Rockstar
2 years ago

Can you share a sample data or a pbix file so I take a look?

  • _AAndrade's avatar
    _AAndrade
    Resident Rockstar
    2 years ago

    Anonymous  you need to give me access

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Access granted

      • _AAndrade's avatar
        _AAndrade
        Resident Rockstar
        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)
    )