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

3 Replies

  • 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