Tableau : Week number of the month calculation | Tableau
DATEPART('week',[Date],'monday')DATEPART('week',DATETRUNC('month',[Date]),'monday')
+1
----------------------------------------------------
Calculate WEEK OF THE MONTH in TABLEAU
--------------------------------
a=Get week # of the year using
datepart('week',[Date],'monday')
here monday is start of the week i.e.,
monday to sunday is one week....
b= get week # of start date of each
month
datepart('week',datetrunc('month',[Date]),'monday')
a-b+1 is the required output
#tableau #tableaudesktop