MoM% how to remove last month

[KaroRoza]

Hello,

I try to caclucate MoM % change. I am getting data for following month which I do not want to display. For this month, I do not want to see Nov line ( in yellow). I have data loaded in Excel "CostingRun" for each product I have PVC on monthy basis : "ValidFrom" - 01/xx/xxxx. 

My formulas are:

PM PVC = CALCULATE(AVERAGE(CostingRun[PVC]),DATEADD(CostingRun[Valid from].[Date],-1,MONTH))

MoM % = DIVIDE(AVERAGE(CostingRun[PVC])-[PM PVC],[PM PVC])

Please help me how to do not dispaly last 'artificial' month in the table?

Many thanks,

Karolina

[KaroRoza]

@FreemanZ thank you very much.

[johnt75]

You could create a column on your date table like

Today or Before = 'Date'[Date] <= TODAY()

and use that as a filter on your visuals.

[KaroRoza]

hi @johnt75 

it doesn't work. I have data loaded in excel on monthy basis, with the last data 01.10.2024. In next week I will have next month data added with 01.11.2024.

[johnt75]

It should work if you select "True". November 2024 should then disappear.

[FreemanZ]

hi @KaroRoza ,

try like:

MoM %= 

IF(

   AVERAGE(CostingRun[PVC])=BLANK(),

   BLANK(),

DIVIDE(AVERAGE(CostingRun[PVC])-[PM PVC],[PM PVC])

)

[KaroRoza]

hi @FreemanZ 

I applied it to "MoM% 2" and it doesnt help. I still have November as Power Bi caclulcated data for October ( which is -1 Month in my data).

[FreemanZ · Accepted solution]

hi @KaroRoza ,

change the other measure as well to:

PM PVC = 

IF(

AVERAGE(CostingRun[PVC]) =BLANK(),

BLANK(),

CALCULATE(AVERAGE(CostingRun[PVC]),DATEADD(CostingRun[Valid from].[Date],-1,MONTH))

)