问题
How to get the date of the end of a month.
上次修改日期： 20 Dec 2023
环境
- Tableau Desktop 2022.3+
答案
Because there is no native date function to determine the end of the month from a date field, create a date calculation as instructed below to obtain the end of the month.
DATEADD('day',-1,(DATEADD('month',1,DATETRUNC('month',[Order Date]))))
其他信息
Vote on the Tableau Community Idea to have a default function added to the product.感谢您提供该文章是否有效的反馈。
打开新案例
继续搜索
知识库
社区
产品帮助
培训和教程