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.
CW | StoreID | CatID | MatID | SaleVolume |
1 | Store1 | 2 | 1 | $ 18,674.64 |
1 | Store1 | 3 | 1 | $ 15,118.37 |
1 | Store1 | 1 | 1 | $ 107,588.30 |
1 | Store2 | 2 | 1 | $ 14,010.44 |
1 | Store2 | 3 | 1 | $ 9,789.39 |
1 | Store2 | 1 | 1 | $ 28,643.33 |
1 | Store3 | 2 | 1 | $ 14,680.86 |
1 | Store3 | 3 | 1 | $ 12,438.25 |
1 | Store3 | 1 | 1 | $ 41,714.96 |
1 | Store4 | 2 | 1 | $ 7,908.21 |
1 | Store4 | 3 | 1 | $ 17,931.38 |
1 | Store4 | 1 | 1 | $ 39,634.22 |
2 | Store1 | 2 | 1 | $ 19,838.09 |
2 | Store1 | 3 | 1 | $ 12,786.31 |
2 | Store1 | 1 | 1 | $ 44,042.58 |
2 | Store2 | 2 | 1 | $ 15,187.15 |
2 | Store2 | 3 | 1 | $ 11,641.98 |
2 | Store2 | 1 | 1 | $ 24,876.50 |
2 | Store3 | 2 | 1 | $ 7,848.64 |
2 | Store3 | 3 | 1 | $ 9,554.36 |
2 | Store3 | 1 | 1 | $ 20,857.48 |
2 | Store4 | 2 | 1 | $ 7,537.00 |
2 | Store4 | 3 | 1 | $ 6,441.51 |
2 | Store4 | 1 | 1 | $ 8,110.98 |
3 | Store1 | 2 | 1 | $ 20,855.73 |
there are 52 weeks in column CW for four stores .
Weeding season weeks are- 1,2,3,49,50,51 and 52.
How can I calculate - A measure that calculates the total amount of sales during the Wedding Season.
Solved! Go to Solution.
HI @Anonymous ,
You can try this:
Weeding Season Sales =
CALCULATE( SUM('Table'[SaleVolume]) ,'Table'[CW] IN {1, 2, 3, 49, 50, 51, 52})
Hi, @Anonymous
Has your problem been solved, if so, please consider Accept a correct reply as the solution. If not, please provide more details and the output you expect.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI @Anonymous ,
You can try this:
Weeding Season Sales =
CALCULATE( SUM('Table'[SaleVolume]) ,'Table'[CW] IN {1, 2, 3, 49, 50, 51, 52})
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |