Forum Discussion

Zeba_Lodhi's avatar
Zeba_Lodhi
Frequent Visitor
8 years ago

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_Lodhi's avatar
    Zeba_Lodhi
    Frequent 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's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Zeba_Lodhi

     

    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