Forum Discussion

UncleLewis's avatar
UncleLewis
Responsive Resident
3 years ago

ENDOFQUARTER Time Intelligence Function

ENDOFQUARTER Time Intelligence Function seems to not work correctly. What am I missing here?   Thanks -w  
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

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's avatar
    UncleLewis
    Responsive Resident
    3 years ago

    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's avatar
      UncleLewis
      Responsive Resident
      3 years ago
      Bump. Any ideas? Thanks, -w