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.
{"ft_lang_label":"__label__en","ft_lang_prob":0.9080839,"math_prob":0.971565,"size":1110,"snap":"2019-13-2019-22","text_gpt3_token_len":320,"char_repetition_ratio":0.10759494,"word_repetition_ratio":0.2747253,"special_character_ratio":0.29009008,"punctuation_ratio":0.18677042,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9885648,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2019-03-24T15:27:06Z\",\"WARC-Record-ID\":\"<urn:uuid:0a5273c1-00cb-4d2f-96bb-263d3bfc38cd>\",\"Content-Length\":\"101216\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:3e587a7f-45d4-467f-8320-3c360e5cffad>\",\"WARC-Concurrent-To\":\"<urn:uuid:5897099e-7d0d-424b-91bf-f31a87026d4e>\",\"WARC-IP-Address\":\"204.93.79.205\",\"WARC-Target-URI\":\"https://community.tableau.com/thread/258519\",\"WARC-Payload-Digest\":\"sha1:3G5EDN5TISTBTGPKVKB3PPNQOQTCDCOT\",\"WARC-Block-Digest\":\"sha1:XS5BX5SM5MGVEDQ74KLHQWJQKUELMBZW\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2019/CC-MAIN-2019-13/CC-MAIN-2019-13_segments_1552912203462.50_warc_CC-MAIN-20190324145706-20190324171706-00142.warc.gz\"}"}