Hiding incomplete months in a Matrix

[imrraza]

Hello all,

I am new to this, so please excuse me if I have not logged this correctly.

I have a data with two dates (start and end) and I need to get a running total based on the duration between the two dates. However if the month is incomplete I dont want the total to continue

Sample dataset

Desired outcome (without the highlited )

Any help / guidance most appreciated.

[PaulDBrown]

What measure are you using in the visual?

[imrraza]

Thank you for replying to my post and I apologies for being a bit cryptic.

I am using a very simple count of one of the columns.

Below is a snapshot from Power BI.

I need the months to be cumulative however only until the relevant month.

e.g. for Jan 2022 it should show me a running total from Jan until Jun/Jul