Calculate Percent Change of a Measure

[bhmiller89]

I have a measure called EHR (effective hourly rate) which = Sum(revenue)/Sum(labor hours)

I put the measure into a matrix using the profitability date.

I need a way to calculate the %change date over date (preferably Quarter over Quarter) but I don't know how to do this without the EHR data being in a column. 

[Eric_Zhang]

---

@bhmiller89 wrote:

I have a measure called EHR (effective hourly rate) which = Sum(revenue)/Sum(labor hours)

I put the measure into a matrix using the profitability date.

I need a way to calculate the %change date over date (preferably Quarter over Quarter) but I don't know how to do this without the EHR data being in a column. 

---

@bhmiller89

You may need 3 measures and one calendar table. See more details in the attached pbix file.

EHR = Sum('datatable'[revenue])/Sum('datatable'[labor hours])

EHR Last Quarter = CALCULATE([EHR], PREVIOUSQUARTER('calendar'[Date]))

%change = [EHR]-[EHR Last Quarter]

[OpenDataLab]

I would refer you to this article from the guys from sqlbi.  This has a lot of good advice on writing time intelligence calculations.

http://www.daxpatterns.com/time-patterns/

Let me know how you get on.