Automated MTD Calculation Ideas

PHOTO EMBED

Thu Apr 06 2023 17:33:17 GMT+0000 (Coordinated Universal Time)

Saved by @yoikodata ##tableau ##dates

IF MONTH([Order Date]) = MONTH(MAKEDATE(2017, 12, 15))

AND YEAR([Order Date]) = YEAR(MAKEDATE(2017, 12, 15))

AND DAY([Order Date]) <= DAY(MAKEDATE(2017, 12, 15))

THEN [Sales]

END

_______________________________

[TODAY] is a parameter, or can be replaced by the function TODAY()


IF DATEDIFF('year', [Order Date], [Today]) = 0 

AND DATEDIFF('month', [Order Date], [Today]) = 0 

AND [Order Date] <= [Today]

THEN [Sales]

END

content_copyCOPY

Few ways of creating a MTD calculation in Tableau