Forum Discussion
Anonymous
2 years agoNot applicable
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...
- 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
2 years agoResident Rockstar
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)
)Anonymous
2 years agoNot applicable
Thank you. This has worked. Really appreciate the help