Tableau - Date Truncation

Return the first day of the week, month, quarter or year using DATETRUNC


                    DATETRUNC(date_part, date, [start_of_week])
                     

The date_part can be:

  • day
  • week
  • month
  • quarter
  • year

[start_of_week] is an optional parameter which can be any day of the week (i.e "Monday", "Tuesday", etc)

Example

Return the first day of this year


                    DATETRUNC('year', TODAY())
                     

Return the first day of the quarter


                    DATETRUNC('quarter', TODAY())
                     

Return the first day of the month one year ago


                    DATETRUNC('month', TODAY() -365)
                     

Some tips:

  • Convert to an exact date
  • Change data type to discrete

These calculations come in handy when finding the number of days in the month, quarter or year dynamically.





Services
  • SEO
  • Online Advertising
  • Online Ordering For Restaurants
  • Data Analytics

  • External Resources 4 Developers
  • CSS Tricks
  • MDN

  • Dash-Intel is a Power BI and Tableau resource site for data visualization and building BI dashboards.

    Data Analytics consultants in Edmonton, Alberta specializing in Tableau and marketing analytics

    Copyright 2021 Dash-Intel.com Terms / All rights reserved.
    Powered By The Order Guys