Want MoM% Change, Quarter % change like given image

[prakash_satya59]

Dear Team

I want to know How to get % MOM change, quarterly average and % qtr change as highlighte in image

my measure is "Average bill rate"

I will be really gratefull. Its very urgent requirement.

[prakash_satya59]

Thanks Stephen

[v-stephen-msft · Accepted solution]

Hi @prakash_satya59 ,

Here's my solution.

1.Create a calendar table.

Calendar = ADDCOLUMNS(CALENDAR(DATE(2021,8,1),DATE(2022,12,31)),"YearQuarter",YEAR([Date])&"-"&QUARTER([Date]))

2.Create the following measures.

% MOM change = 
var _previous=CALCULATE([Average Bill Rate],PREVIOUSMONTH('Calendar'[Date]))
return DIVIDE([Average Bill Rate]-_previous,_previous)

Quarterly Average = AVERAGEX(FILTER(ALLSELECTED('Calendar'),[YearQuarter]=MAX('Calendar'[YearQuarter])),[Average Bill Rate])

Quarter % change = var _previous=CALCULATE([Average Bill Rate],PREVIOUSQUARTER('Calendar'[Date]))
return DIVIDE([Quarterly Average]-_previous,_previous)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.