Please help me in creating a condition for
last 30 days from todaylast monthcurrent month
month([Order Date])= MONTH(TODAY())-1 and year(today())=year([Order Date])
last 30 days from today
[Last 30 Days] = SUM(IF TODAY() - ATTR([YOUR DATE FIELD]) <= 30 THEN [SALES] ELSE 0 END)
Please mark the answer if it helps you so that it can help others as well
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...