Forum Discussion

eszimmerman's avatar
eszimmerman
Regular Visitor
5 years ago

Measures - Leading Indicators & Future Forecasting

I'm working on getting printer metrics for my company's network fleet and I've run into a bit of a snag.   I can get trailing indicators just fine, but can't seem to get leading going. The metri...
Need Help
eszimmerman's avatar
eszimmerman
Regular Visitor
5 years ago

I've got it down a bit further... any asistance appreciated.  Thanks!

  1. B&W MTD =
  2. VAR __PREVIOUSMONTH =
  3. (TOTALMTD ( SUM('printerMeterHistory'[B&W]), DATEADD('printerMeterHistory'[pmh_detailedMeterReadDate].[Date], -1, MONTH)))
  4. VAR __CURRENTMONTH =
  5. (TOTALMTD ( CALCULATE( (MAX('printerMeterHistory'[pmh_detailedMeterReadDate], DATEADD('printerMeterHistory'[pmh_detailedMeterReadDate].[Date], 0, DAY) ) )
  6. VAR __TOTAL = IF((__CURRENTMONTH - __PREVIOUSMONTH >= 0), __CURRENTMONTH - __PREVIOUSMONTH, __CURRENTMONTH)
  7. RETURN __TOTAL
eszimmerman's avatar
eszimmerman
Regular Visitor
5 years ago

Getting there...

 

B&W MTD =
VAR __PREVIOUSMONTH =
(TOTALMTD ( SUM('printerMeterHistory'[B&W]), DATEADD('printerMeterHistory'[pmh_detailedMeterReadDate].[Date], -1, MONTH)))
VAR __CURRENTMONTH =
(TOTALMTD ( CALCULATE( (MAX( printerMeterHistory[pmh_detailedMeterReadDate].[Date] ) ) )
VAR __TOTAL = IF((__CURRENTMONTH - __PREVIOUSMONTH >= 0), __CURRENTMONTH - __PREVIOUSMONTH, __CURRENTMONTH))