Forum Discussion
Zeba_Lodhi
8 years agoFrequent Visitor
Unable to plot calculated growth rate measure
First, I made two measures to calculate current (Current month AR)and previous month recharge (Previous Month AR) then a third to calculate the growth rate.I am unable to plot the Previous month AR a...
Zeba_Lodhi
8 years agoFrequent Visitor
First, I made two measures to calculate current (Current month AR)and previous month recharge (Previous Month AR) then a third to calculate the growth rate.I am unable to plot the Previous month AR and Growth Rate in a chart. What could be wrong?.Previous month AR = CALCULATE('Dashboard_Daily_2017-10-04'[Current Month AR], DATEADD('Dashboard_Daily_2017-10-04'[Data_Date].[Date], -1, MONTH))
Growth rate = 'Dashboard_Daily_2017-10-04'[Current Month AR]/[Previous month AR]-1