Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I would like to calculate the number of pending tasks based on previous month.
Example:
Solved! Go to 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
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
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |