Skip to content

Instantly share code, notes, and snippets.

@mayrund

mayrund/Get first day of current quarter

Created April 27, 2015 10:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mayrund/4c8af40d3a7fc863916b to your computer and use it in GitHub Desktop.
Save mayrund/4c8af40d3a7fc863916b to your computer and use it in GitHub Desktop.
Download ZIP
SSAS Snippets
Raw
Get first day of current quarter
#SSAS snippet
=dateadd("q",datepart("q",today())-1,CDate("1/1/" & today().year))
Raw
Get last day of current quarter
#SSAS
=dateadd("d",-1,dateadd("q",datepart("q",today()),CDate("1/1/" & today().year)))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment