How to calculate pending tasks

[Anonymous]

Hi,

I would like to calculate the number of pending tasks based on previous month.

Example:

[v-piga-msft · Accepted solution]

Hi @Anonymous,

Try the measures below.

Concude = CALCULATE(COUNT('Table'[Date]),FILTER('Table','Table'[Type]="Concude"&&MONTH('Table'[Date])=MONTH(MAX('Table'[Date]))))

Open = CALCULATE(COUNT('Table'[Date]),FILTER('Table','Table'[Type]="Open"&&MONTH('Table'[Date])=MONTH(MAX('Table'[Date]))))

Pending = IF([Open]-[Concude]=0,CALCULATE([Open]-[Concude],FILTER(ALL('Table'),'Table'[Date].[MonthNo]=MAX('Table'[Date].[MonthNo])-1)),[Open]-[Concude])

Best Regards,

Cherry