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]))

Answered YOY (%) = IF([Answered LY] > 0, [Answered] / [Answered LY]-1,1)

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 extended YOY (%) = IF([Availability extended LY (%)] > 0, [Availability extended (%)] - [Availability extended LY (%)],1)

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]))

Availability reduced YOY (%) = IF([Availability reduced LY (%)] > 0, [Availability reduced (%)] - [Availability reduced LY (%)],1)

Availability YOY (%) = IF([Availability LY (%)] > 0, [Availability (%)] - [Availability LY (%)],1)

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 Handle Time YOY (%) = IF([Avg Handle Time LY (s)] > 0, [Avg Handle Time (s)] / [Avg Handle Time LY (s)]-1,1)

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]))

Avg Wait Time YOY (%) = IF([Avg Wait Time LY (s)] > 0, [Avg Wait Time (s)] / [Avg Wait Time LY (s)]-1,1)

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]))

Occupancy YOY (%) = IF([Occupancy LY (%)] > 0, [Occupancy (%)] - [Occupancy LY (%)],1)

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]))

Self Finish Rate YOY (%) = IF([Self Finish Rate LY (%)] > 0, [Self Finish Rate (%)] - [Self Finish Rate LY (%)],1)

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 neg. YOY (%) = IF([Service Level neg. LY (%)] > 0, [Service Level neg. (%)] - [Service Level neg. LY (%)],1)

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]))

Service Level pos. YOY (%) = IF([Service Level pos. LY (%)] > 0, [Service Level pos. (%)] - [Service Level pos. LY (%)],1)

Service Level YOY (%) = IF([Service Level LY (%)] > 0, [Service Level (%)] - [Service Level LY (%)],1)

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]))

Total Completed YOY (%) = IF([Total Completed LY] > 0, [Total Completed] / [Total Completed LY]-1,1)

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]))

Unanswered YOY (%) = IF([Unanswered LY] > 0, [Unanswered] / [Unanswered LY]-1,1)