ENDOFQUARTER Time Intelligence Function

[UncleLewis]

ENDOFQUARTER Time Intelligence Function seems to not work correctly. What am I missing here?

Thanks

-w

[amitchandak]

@UncleLewis , Use a column like

end of qtr =

var _mod = MOD(MONTH([Date]),3)
var _rem = 3-1*if(_mod=0,3,_mod)
return EOMONTH([Date],_rem)

Endofquarter need continuous dates and end at last available date

[UncleLewis]

Thanks amitchandak,

I added a date table: 1/1/2023 - 12/31/2023 and market as a Date Table.
I joined date to date in the Transaction Table (Trx)

I entered 2 transactions in the trx tabl both on 1/15/2023

Still when I use ENDOFQUARTER in Calculated Column I get 1/15/2023.

What am I missing here?

Thanks,

-w

[UncleLewis]

Bump. Any ideas? Thanks, -w