Accumulated Sum by month and semester

[hettoritosi]

Hi guys, I need a help here, I have the following problem:

JAN 10
FEB 10
MAR 10
APR 10

MAY 10
JUN 10
JUL 10
AUG 10

I have a month slicer

When I select  March

I'd like this result: 30

But When I select July, I'd like this result: 20

Anyone could help me please?

[v-danhe-msft · Accepted solution]

Hi @hettoritosi ,

Could you have a date column? If you have a date column, you could refer to below steps:

Create a calculated column:

Legend = IF([Date].[MonthNo]<6,1,2)

Create a measure:

Measure = CALCULATE(SUM(Table1[Value]),FILTER(ALL(Table1),'Table1'[Date]<=SELECTEDVALUE(Table1[Date])&&'Table1'[Legend]=MAX('Table1'[Legend])))

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He

[edhans]

Why is march 30 and july 20?

[hettoritosi]

Cause the semester, i need to sum from Jan to Jun  and  Jul to Dec. 

[edhans]

Then you will need to add data to your table that shows that Jan-Jun are in semester 1, and Jul-Dec are in Semester 2. In Power Query, just add a Semester column that says:

each if [Month] <= 6 then 1 else 2

Then any SUM() function in DAX on those values would split if you had the Semeseter column visible in the visual.

You need a date table to do this right.