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 Experts,
we need to sum of sales month
Month | grade | Sales | Month wise sales |
Jan | dsa | 43 | 2040 |
Jan | fd | 765 | 2040 |
Jan | hj | 9 | 2040 |
Jan | gd | 23 | 2040 |
Jan | sh | 876 | 2040 |
Jan | fdsh | 324 | 2040 |
Feb | dsg | 43 | 1345 |
Feb | gfd | 876 | 1345 |
Feb | kjh | 98 | 1345 |
Feb | hjkh | 1 | 1345 |
Feb | gfd | 43 | 1345 |
Feb | ewr | 9 | 1345 |
Feb | kjh | 34 | 1345 |
Feb | qwd | 241 | 1345 |
4 th column formula required in powerbi sum(jan sales) is 2040 and sum(Feb sales) is 1345
Thanks,
Tom
Solved! Go to Solution.
Hi @Anonymous ,
use the following measure:
Hope this helps !!
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
@Anonymous You can use This method to fulfill your reuirement .
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Thanks and regards
Harish Mishra
is it possible to create measure format ?
@Anonymous For measure, you may use the solution suggested by @jaideepnema
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂 (Hit the thumbs up button!)
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)
https://www.vivran.in/
Connect on LinkedIn
Hi @Anonymous ,
use the following measure:
Hope this helps !!
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Hello @Anonymous ,
Assuming the requirement is a calculated column, you may use the following:
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 |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |