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
Anonymous you need to give me access
Anonymous
2 years agoNot applicable
Access granted
- _AAndrade2 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) )- Anonymous2 years agoNot applicable
Thank you. This has worked. Really appreciate the help