Forum Discussion

Applicable88's avatar
Applicable88
Impactful Individual
5 years ago
Solved

Percentage Value as moving average development

Hello,   I have a division of two values which are summarized as a Measure. I use this measure in a barchart where I can see monthly  percentage value of it.  What I now want to display is a 180 d...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    Applicable88 , Try a measure like

    CALCULATE(COUNTX(values(Mastercalendar[Date]),[Measure in Percent])/6, DATESINPERIOD(Mastercalendar[Date],LASTDATE(Mastercalendar[Date].[Date]),-6,MONTH))

amitchandak's avatar
amitchandak
Super User
5 years ago

Applicable88 , Try a measure like

CALCULATE(COUNTX(values(Mastercalendar[Date]),[Measure in Percent])/6, DATESINPERIOD(Mastercalendar[Date],LASTDATE(Mastercalendar[Date].[Date]),-6,MONTH))

  • Applicable88's avatar
    Applicable88
    Impactful Individual
    5 years ago

    Hello amitchandak,

    thanks so much, but I can't display it. the barchart is always showing me no values, no graph for the moving average and I don't know why.

    When I use a table to visualize this first I have a value MA Value in every month. Switching back to the chart there is only a bar chart with the absolute monthly value but no graph. I tried also other bar chat visuals with no success. What might be the problem here?