Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Martin Wing]

I am trying to show the monthly percentage difference in a 12-month rolling average. I created the rolling average using a quick measure and tried creating another quick measure for month-over-month % change, but it is not calculating correctly. 

Does anyone have an idea of what is happening? 

——————————
Martin
——————————

[Brian Connelly]

?Can you share the calculations that you are using?  It is hard to make an assessment without any indications of what you did.

——————————
Brian Connelly
——————————
——————————————-

[Kristi Cantor]

Did you try creating a measure for Last Month 12 Month rolling average and then using it in the % change?
I usually create a current total, a last month total and then do my % change by something like : DIVIDE([ThisMonth]-[LastMonth]),[LastMonth]

——————————
Kristi Cantor
KaTom Restaurant Supply
Kodak TN
4235865758
——————————
——————————————-

[Martin Wing]

Sorry – below are the calculations from the “Quick Measures”

RA Sessions =
IF(
ISFILTERED(‘Date'[Date]),
ERROR(“Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column.”),
VAR __LAST_DATE = ENDOFMONTH(‘Date'[Date].[Date])
VAR __DATE_PERIOD =
DATESBETWEEN(
‘Date'[Date].[Date],
STARTOFMONTH(DATEADD(__LAST_DATE, -11, MONTH)),
__LAST_DATE
)
RETURN
AVERAGEX(
CALCULATETABLE(
SUMMARIZE(
VALUES(‘Date’),
‘Date'[Date].[Year],
‘Date'[Date].[QuarterNo],
‘Date'[Date].[Quarter],
‘Date'[Date].[MonthNo],
‘Date'[Date].[Month]
),
__DATE_PERIOD
),
CALCULATE(SUM(‘Overview'[Sessions]), ALL(‘Date'[Date].[Day]))
)
)

RA Sessions MoM% =
IF(
ISFILTERED(‘Date'[Date]),
ERROR(“Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column.”),
VAR __PREV_MONTH = CALCULATE([RA Sessions], DATEADD(‘Date'[Date].[Date], -1, MONTH))
RETURN
DIVIDE([RA Sessions] – __PREV_MONTH, __PREV_MONTH)
)

As you can see the MoM change is not calculating correctly.

——————————
Martin Wing
Vice President
PCM
Yorba Linda CA
9512850487
——————————
——————————————-

[William Skelley]

Hi Martin:

I think this measure could help you and has flexibility to change your months/timeframes. It is set at 3 now. I hope this helps you. It’s a 3-month moving average formula.

Best regards,

Bill Skelley

——————————
William Skelley
01106
Longmeadow MA
8602807221
——————————
——————————————-