Month Wise Sum of sale

[Anonymous]

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

[HarishKM]

@Anonymous  You can use This method to fulfill your reuirement .

COmmunity = CALCULATE(SUM(Sheet1[Sales]),ALL(Sheet1[grade]))

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

[Anonymous]

is it possible to create measure format ?

[vivran22]

@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

[jaideepnema · Accepted solution]

Hi @Anonymous ,
use the following measure:

Month-Wise-Sales = CALCULATE(SUM('Table'[Sales]),ALLEXCEPT('Table','Table'[Month]))

This will give you the desired output:

Hope this helps !!

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

[vivran22]

Hello @Anonymous ,

Assuming the requirement is a calculated column, you may use the following:

Formula =

VAR _CurrentMonth = 'Table'[Month]

VAR _Filter =

FILTER(

'Table',

'Table'[Month] = _CurrentMonth

)

VAR _Sum = SUMX(_Filter,'Table'[Sales])

RETURN

_Sum

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