ENDOFQUARTER Time Intelligence Function

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