Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
106 | |
89 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |