Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a projection measure, previously it used to calculate the actual proj month usage + last 2 month usage, i want to make few changes to it. Instead of the last 2 month i want to use last n month usage. The last n month usage should use the following logic-
The current measure I use is -
Tot. Act. proj. Mon. Usage = [Act. proj. Mon. Usage]+[Act. Last2 Mon Comp.Usage]
Act. Last2 Mon Comp.Usage = CALCULATE(count('DO Vs Tag'[Procedure Credit Owner]), FILTER('DO Vs Tag','DO Vs Tag'[Last 2 Mon Procedure]=1))
The measure I need to modify is Tot. Act. proj. Mon. Usage.
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |