Sum for first or second half of year depending on today's date

[Anonymous]

Hello,

I'm looking for some help trying to calculate the total billed amount for either the first or second half of the year depending on the date. i.e. if today is April 1 then calculate the billed amount for months 1 to 6 (regardless if no data exists for Apr/May/Jun) and if July 1 then calculate amounts for months 7 to 12. I do have a calendar table created however I can't seem to get my head around the syntax to put it together.

Any help would be appreciated!

Thank you!

[Anonymous · Accepted solution]

@Anonymous  - Please try the following:

1. If you don't have a column for semesters (half-years) in your calendar table, add it.

2. Create a measure similar to this:

Your Sum Measure = 
var current_semester = CALCULATE(VALUES('Date'[Semester]), 'Date'[Date] = TODAY())
return CALCULATE(SUM(YourTable[YourColumn]), 'Date'[Semester] = current_semester)

Hope this helps,

Nathan

[Anonymous · Accepted solution]

@Anonymous  - Please try the following:

1. If you don't have a column for semesters (half-years) in your calendar table, add it.

2. Create a measure similar to this:

Your Sum Measure = 
var current_semester = CALCULATE(VALUES('Date'[Semester]), 'Date'[Date] = TODAY())
return CALCULATE(SUM(YourTable[YourColumn]), 'Date'[Semester] = current_semester)

Hope this helps,

Nathan

[Anonymous · Accepted solution]

Thanks Natel, it worked perfectly.