Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Community,
I need to calculate prev week spend which I tried from my end but at the measure total getting wrong result. Attaching sample data and screen shot below. Any help would be highlighly appreciated.
Spend | Week | Date | Expected Result |
120 | 1 | 01-Jan-23 |
|
130 | 2 | 02-Jan-23 | 120 |
150 | 2 | 03-Jan-23 | 130 |
120 | 2 | 04-Jan-23 | 150 |
110 | 2 | 05-Jan-23 | 120 |
90 | 2 | 06-Jan-23 | 110 |
56 | 2 | 07-Jan-23 | 90 |
58 | 2 | 08-Jan-23 | 56 |
36 | 3 | 09-Jan-23 | 58 |
90 | 3 | 10-Jan-23 | 36 |
120 | 40 | 01-Oct-22 | 0 |
230 | 40 | 02-Oct-22 | 120 |
220 | 41 | 03-Oct-22 | 230 |
100 | 41 | 04-Oct-22 | 220 |
Solved! Go to Solution.
Hi,
you need to add a Year column in your Table
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
Hi,
you need to add a Year column in your Table
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
@serpiva64 Thanks a ton! you saved me again 😊
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |