Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a table wiht data Outstanding:
Date | Code Trade | Outstanding | Result : Cumul |
01/01/2022 | A | 500 | 650 |
02/01/2022 | A | 500 | 650 |
03/01/2022 | A | 500 | 650 |
04/01/2022 | A | 500 | 650 |
05/01/2022 | A | 500 | 550 |
01/01/2022 | B | 50 | 650 |
02/01/2022 | B | 50 | 650 |
03/01/2022 | B | 50 | 650 |
04/01/2022 | B | 50 | 650 |
05/01/2022 | B | 50 | 550 |
01/01/2022 | C | 100 | 650 |
02/01/2022 | C | 100 | 650 |
03/01/2022 | C | 100 | 650 |
04/01/2022 | C | 100 | 650 |
I try to create a measure that allows to accumulate the outstanding over 5 years in daily (like in the column "Result:Cumul").
An idea pls?
Thnks
Solved! Go to Solution.
Hi @majid_75 ,
Please try:
Result:Cuml = CALCULATE(SUM('Table'[Outstanding]),FILTER(ALL('Table'),[Date]=MAX([Date])))
Output:
Besides, it seems that you want accumulate the outstanding over 5 years in daily, the result is different from Result:Cumul. If you want accumulate the outstanding over 5 years in daily, please try:
Over 5 Years = CALCULATE(SUM('Table'[Outstanding]),FILTER(ALL('Table'),[Date]<=MAX('Table'[Date])&&[Date]>=EDATE(MAX('Table'[Date]),-60)))
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @majid_75 ,
Please try:
Result:Cuml = CALCULATE(SUM('Table'[Outstanding]),FILTER(ALL('Table'),[Date]=MAX([Date])))
Output:
Besides, it seems that you want accumulate the outstanding over 5 years in daily, the result is different from Result:Cumul. If you want accumulate the outstanding over 5 years in daily, please try:
Over 5 Years = CALCULATE(SUM('Table'[Outstanding]),FILTER(ALL('Table'),[Date]<=MAX('Table'[Date])&&[Date]>=EDATE(MAX('Table'[Date]),-60)))
Output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
For exemple, the 01/01/2022 is A + B +C = 650, etc... the 05/01/2022 is A+B=550
I try to create a measure that allows me to cumulate the Outstanding according to the code.
I try to create a measure that allows me to cumulate the Outstanding according to the code.
The result I want is the Result column
Thks
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
User | Count |
---|---|
85 | |
75 | |
71 | |
69 | |
55 |
User | Count |
---|---|
98 | |
96 | |
92 | |
78 | |
70 |