Forum Discussion
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 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
2 Replies
- Zeba_LodhiFrequent 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
- v-haibl-msft
Microsoft Employee
What do you mean about "unable to plot the Previous month AR and Growth Rate in a chart"? In the screenshot, I can see that the measures are displayed in the same Table visual.
Best Regards,
Herbert