Get last day of quarter from quarter number and year

[obriaincian]

I'm looking to see if I can get the last date in a quarter.

I have 3 columns

- Year/Quarter (Formatted like 2019Q4)

- Quarter which contains the quarter number

- Year which contains the Year number i.e. 2019

I know the ENDOFQUARTER functions gives you the last day in a quarter however you need to input a date for this to work.

Is there another way to do it with the data I have above?

Thanks

[amitchandak · Accepted solution]

@obriaincian , Try like

end of qtr =

eomonth( date([Year], 3*[Qtr], 1),0)

[obriaincian]

@amitchandak thank you, would you mind explaining the logic please