Month Completion formula only if filtered month is equal to current month

[Arnoux]

Hi Everyone.

So I have a problem and think I have a solution, but not sure if it is possible

I have a measure built in to show me how far the current month is completed and shows me a perc

MonthCompletion = CALCULATE( DAY(TODAY()-1)/30)

I use this in the targets for each month to keep it Linearised against the Actuals

My problem now is that when I filter for prev months the Target KPI is multiplaying by a perc of the current month completion

Linearised Booking Target = dim_budget[Target Bookings]*[MonthCompletion]

So my question is,.. Is there a way where I can write an If statement in to change the month completion formula to show 1 or 100% when filtered month is not equal to Month(Now())

Thanks in Advance

Arnoux

[v-yuezhe-msft · Accepted solution]

Hi @Arnoux,

Could you please post sample data of your scenario. If you have Date column in your table, you can use the following formula to create MonthCompletion measure.

MonthCompletion = IF(MONTH(MAX('Date'[Date]))=Month(NOW()), CALCULATE(DAY('Date'[Today]-1)/30), 1)

And please check the following screenshots about what MonthCompletion is set in different months.


Thanks,
Lydia Zhang

[Arnoux]

Hi Lydia. Than you so much.

What you have in that picture is exactly what i need !

How did you get that right.

Regards 

Arnoux