LM LQ LY Comparison

This measure category contains measures built from almost all fact tables using a filter, calculated from the selected data. LM Measures filter data from the last month, LQ Measures filter data from the last quarter and finally LY Measures filter data from the same period of the last year.

info

Main Focus is on comparing the volumes and the most important KPIs with data for the same period last year, last quarter or last month.

Measure name = DAX formulas and expressions

Answered LM = CALCULATE ([Answered], DATEADD ('DATE'[Date], -1, MONTH ))

Answered LM (%) = CALCULATE ([Answered]/[Total Completed], DATEADD ('DATE'[Date], -1, MONTH ))

Answered LQ = CALCULATE ([Answered], DATEADD ('DATE'[Date], -1, QUARTER ))

Answered LQ (%) = CALCULATE ([Answered]/[Total Completed], DATEADD ('DATE'[Date], -1, QUARTER ))

Answered LY = CALCULATE ([Answered], SAMEPERIODLASTYEAR ('DATE'[Date]))

Answered LY (%) = CALCULATE ([Answered]/[Total Completed], SAMEPERIODLASTYEAR ('DATE'[Date]))

Availability extended LM (%) = CALCULATE (([Answered]+[Forwarded])/([Answered]+[Forwarded]+[Abandoned]-[Abandoned before SLT]), DATEADD ('DATE'[Date], -1, MONTH ))

Availability extended LQ (%) = CALCULATE (([Answered]+[Forwarded])/([Answered]+[Forwarded]+[Abandoned]-[Abandoned before SLT]), DATEADD ('DATE'[Date], -1, QUARTER ))

Availability extended LY (%) = CALCULATE (([Answered]+[Forwarded])/([Answered]+[Forwarded]+[Abandoned]-[Abandoned before SLT]), SAMEPERIODLASTYEAR ('DATE'[Date]))

Availability LM (%) = CALCULATE ([Answered]/([Answered]+[Abandoned]-[Abandoned before SLT]), DATEADD ('DATE'[Date], -1, MONTH ))

Availability LQ (%) = CALCULATE ([Answered]/([Answered]+[Abandoned]-[Abandoned before SLT]), DATEADD ('DATE'[Date], -1, QUARTER ))

Availability LY (%) = CALCULATE ([Answered]/([Answered]+[Abandoned]-[Abandoned before SLT]), SAMEPERIODLASTYEAR ('DATE'[Date]))

Availability reduced LM (%) = CALCULATE ([Answered]/([Answered]+[Abandoned]), DATEADD ('DATE'[Date], -1, MONTH ))

Availability reduced LQ (%) = CALCULATE ([Answered]/([Answered]+[Abandoned]), DATEADD ('DATE'[Date], -1, QUARTER ))

Availability reduced LY (%) = CALCULATE ([Answered]/([Answered]+[Abandoned]), SAMEPERIODLASTYEAR ('DATE'[Date]))

Avg Handle Time LM (hh:mm:ss) = Format [Avg Handle Time LM (s)] in (hh:mm:ss)

Avg Handle Time LM (mm:ss) = Format [Avg Handle Time LM (s)] in (mm:ss)

Avg Handle Time LM (s) = CALCULATE ([Avg Handle Time (s)], DATEADD ('DATE'[Date], -1, MONTH ))

Avg Handle Time LQ (hh:mm:ss) = Format [Avg Handle Time LQ (s)] in (hh:mm:ss)

Avg Handle Time LQ (mm:ss) = Format [Avg Handle Time LQ (s)] in (mm:ss)

Avg Handle Time LQ (s) = CALCULATE ([Avg Handle Time (s)], DATEADD ('DATE'[Date], -1, QUARTER ))

Avg Handle Time LY (hh:mm:ss) = Format [Avg Handle Time LY (s)] in (hh:mm:ss)

Avg Handle Time LY (mm:ss) = Format [Avg Handle Time LY (s)] in (mm:ss)

Avg Handle Time LY (s) = CALCULATE ([Avg Handle Time (s)], SAMEPERIODLASTYEAR ('DATE'[Date]))

Avg Wait Time LM (hh:mm:ss) = Format [Avg Wait Time LM (s)] in (hh:mm:ss)

Avg Wait Time LM (mm:ss) = Format [Avg Wait Time LM (s)] in (mm:ss)

Avg Wait Time LM (s) = CALCULATE ([Avg Wait Time (s)], DATEADD ('DATE'[Date], -1, MONTH ))

Avg Wait Time LQ (hh:mm:ss) = Format [Avg Wait Time LQ (s)] in (hh:mm:ss)

Avg Wait Time LQ (mm:ss) = Format [Avg Wait Time LQ (s)] in (mm:ss)

Avg Wait Time LQ (s) = CALCULATE ([Avg Wait Time (s)], DATEADD ('DATE'[Date], -1, QUARTER ))

Avg Wait Time LY (hh:mm:ss) = Format [Avg Wait Time LY (s)]  in (hh:mm:ss)

Avg Wait Time LY (mm:ss) = Format [Avg Wait Time LY (s)] in (mm:ss)

Avg Wait Time LY (s) = CALCULATE ([Avg Wait Time (s)], SAMEPERIODLASTYEAR ('DATE'[Date]))

Occupancy LM (%) = CALCULATE ([Active Time (s)] / [Ready Time (s)], DATEADD ('DATE'[Date], -1, MONTH ))

Occupancy LQ (%) = CALCULATE ([Active Time (s)] / [Ready Time (s)], DATEADD ('DATE'[Date], -1, QUARTER ))

Occupancy LY (%) = CALCULATE ([Active Time (s)] / [Ready Time (s)], SAMEPERIODLASTYEAR ('DATE'[Date]))

Self Finish Rate LM (%) = CALCULATE ([Finished]/[Answered], DATEADD ('DATE'[Date], -1, MONTH ))

Self Finish Rate LQ (%) = CALCULATE ([Finished]/[Answered], DATEADD ('DATE'[Date], -1, QUARTER ))

Self Finish Rate LY (%) = CALCULATE ([Finished]/[Answered], SAMEPERIODLASTYEAR ('DATE'[Date]))

Service Level LM (%) = CALCULATE ([Answered before SLT]/([Offered]-[Abandoned before SLT]), DATEADD ('DATE'[Date], -1, MONTH ))

Service Level LQ (%) = CALCULATE ([Answered before SLT]/([Offered]-[Abandoned before SLT]), DATEADD ('DATE'[Date], -1, QUARTER ))

Service Level LY (%) = CALCULATE ([Answered before SLT]/([Offered]-[Abandoned before SLT]), SAMEPERIODLASTYEAR ('DATE'[Date]))

Service Level neg. LM (%) = CALCULATE ([Answered before SLT]/[Offered], DATEADD ('DATE'[Date], -1, MONTH ))

Service Level neg. LQ (%) = CALCULATE ([Answered before SLT]/[Offered], DATEADD ('DATE'[Date], -1, QUARTER ))

Service Level neg. LY (%) = CALCULATE ([Answered before SLT]/[Offered], SAMEPERIODLASTYEAR ('DATE'[Date]))

Service Level pos. LM (%) = CALCULATE (([Answered before SLT]+[Abandoned before SLT])/[Offered], DATEADD ('DATE'[Date], -1, MONTH ))

Service Level pos. LQ (%) = CALCULATE (([Answered before SLT]+[Abandoned before SLT])/[Offered], DATEADD ('DATE'[Date], -1, QUARTER ))

Service Level pos. LY (%) = CALCULATE (([Answered before SLT]+[Abandoned before SLT])/[Offered], SAMEPERIODLASTYEAR ('DATE'[Date]))

Total Completed LM = CALCULATE ([Total Completed], DATEADD ('DATE'[Date], -1, MONTH ))

Total Completed LQ = CALCULATE ([Total Completed], DATEADD ('DATE'[Date], -1, QUARTER ))

Total Completed LY = CALCULATE ([Total Completed], SAMEPERIODLASTYEAR ('DATE'[Date]))

Unanswered LM = CALCULATE ([Unanswered], DATEADD ('DATE'[Date], -1, MONTH ))

Unanswered LM (%) = CALCULATE ([Unanswered]/[Total Completed], DATEADD ('DATE'[Date], -1, MONTH ))

Unanswered LQ = CALCULATE ([Unanswered], DATEADD ('DATE'[Date], -1, QUARTER ))

Unanswered LQ (%) = CALCULATE ([Unanswered]/[Total Completed], DATEADD ('DATE'[Date], -1, QUARTER ))

Unanswered LY = CALCULATE ([Unanswered], SAMEPERIODLASTYEAR ('DATE'[Date]))

Unanswered LY (%) = CALCULATE ([Unanswered]/[Total Completed], SAMEPERIODLASTYEAR ('DATE'[Date]))