Sum per month per value

[Tevon713]

Hi all,

This subject may be solve somewhere. I can't seem to get my head around to it. Create measure to sum per month/year of the value. Also there will be a date filter slicer for user selection. See below. Thank you for your help.

Data Table

Year	Month	No. of  Machine
2021	January	20
2021	January	20
2021	January	0
2021	February	20
2021	February	20
2021	February	0
2021	March	20
2021	March	30
2021	March	10
2021	April	20
2021	April	20
2021	April	0
2022	January	10
2022	January	10
2022	January	30
	Total	230

Outputs:

Year	Month	No. of Machine
2021	January	40
2021	February	40
2021	March	60
2021	April	40
2022	January	50
	Total	230

[tackytechtom · Accepted solution]

Hi @Tevon713 l

I pasted your data into a table in PBI:

Then, I created a simple measure:

SumMachineMeasure =  SUM ( Table[No. of  Machine] )

Lastly, I dragged the measure into a table visual with the Year and Month. Note, the year column might have an implicite sum. Choose "don't summarize" instead:

Power BI does the grouping for you by applying filters in the visual.

Let me know if this helps or if you have any questions!

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[tamerj1]

Hi @Tevon713 

create a table visual. Inset the year and the month columns. Make sure to select "don't summarize". 
create a measue

SUM ( TableName[No. of Machine] )

inset the measure into the table.