Using the Countrows Measure with offset months

[Asa94]

Hi all,

I hope you are all well,

I'm trying to use the Countrows function that will show the count per month like below:

My challenge is that I'm struggling to exclude the current/max month (in this example, August) from the count. I do have a Month Offset column in the Dates table to try and reference the offset months.

The count should NOT include the current/max month (in this example, August).

Any ideas on what clause or varaible to add on? 🙂 Thank you

Kind Regards,

Asa

[PaulDBrown · Accepted solution]

Assuming you have a month number in your date table, try

exclude max month =
VAR MaxMonth = CALCULATE(MAX(Date table [month number]), ALLSELECTED(Date Table))

RETURN

IF(MAX(Date table [month number]) = MaxMonth, BLANK(), [your COUNTROW measure])

[Asa94]

Hi Paul,

Thank you for the reply and yes, I do have a month number in my date table

If the measure is a calculated column, will this solution work?