問題
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.感謝您針對本文的效益提供意見回饋。
開啟新案例
繼續搜尋
知識庫
社群
產品說明
訓練及教學課程