4 Replies Latest reply on Jan 31, 2018 1:42 PM by stephen.cavallaro.0

# Calculate measure for first and last day of given month?

I need to take a measure on the first day of the month and then I need to take that same measure on the last day of the month?

• ###### 1. Re: Calculate measure for first and last day of given month?

Something like this, in absence of data:

For First day

{FIXED:SUM(IF MIN(Date)=Date Then Sales END)}

For Last Day

{FIXED:SUM(IF MAX(Date)=Date Then Sales END)}

• ###### 2. Re: Calculate measure for first and last day of given month?

the second [Date] would need to be aggregated, how would you recommend?

• ###### 3. Re: Calculate measure for first and last day of given month?

Yes...it is easy to show with data...Can you attach a Workbook...I would have created a FIXED for MAX and MIN dates and Compared.

• ###### 4. Re: Calculate measure for first and last day of given month?

I would need a calculation that would derive the 1st number (row) and another calculation that would derive the second number.