Period value (month over month change)

Question

Hello gents,&nbsp;I'm new to Power BI and have an issue regarding retreive/calculate period&nbsp;value (month).&nbsp;&nbsp;The datatable looks like this:&nbsp;The column day_balance is ending balance value for each period. I have tried with a Measure calculation but it doesn't summerize column total.&nbsp;Actual Days Period = 
VAR __PREV_MONTH = CALCULATE([Actual Days]; DATEADD('Calendar'[Date]; -1; MONTH))
RETURN
    IF ( ISBLANK([Actual Days]); BLANK(); [Actual Days] - __PREV_MONTH)&nbsp;&nbsp;How can I make a correct calculation period value based monthly "day_balance" value. Appreciate your assistance.

v-yulgu-msft · Accepted Answer

Hi&nbsp;gselvag,
&nbsp;
Please try this measure:
Actual&nbsp;Days&nbsp;Period&nbsp;=VAR&nbsp;__PREV_MONTH&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Actual&nbsp;Days],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALLEXCEPT&nbsp;(&nbsp;Table1,&nbsp;Table1[emp_no]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Table1[period].[Year]&nbsp;=&nbsp;YEAR&nbsp;(&nbsp;MAX&nbsp;(&nbsp;Table1[period]&nbsp;)&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;Table1[period].[MonthNo]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;MONTH&nbsp;(&nbsp;MAX&nbsp;(&nbsp;Table1[period]&nbsp;)&nbsp;)&nbsp;-&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;)RETURN&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(&nbsp;ISBLANK&nbsp;(&nbsp;[Actual&nbsp;Days]&nbsp;),&nbsp;BLANK&nbsp;(),&nbsp;[Actual&nbsp;Days]&nbsp;-&nbsp;__PREV_MONTH&nbsp;)&nbsp;
&nbsp;
Best regards,
Yuliana Gu

Forum Discussion

Period value (month over month change)

2 Replies

Related content

Sales Last month and Last month same period

month over month Change

Change time period (week, Month, Quarter...) on slicer selection

Showing 13 periods

Month Over Month % Change Formula