I'd like one calculation (if possible) that selects only the value (calculation #1 in the attached workbook) from 3 months ago. This calculation will also be used in other IF statements, but I only need the initial calculation.
2 answers
see the attached
this will return a True for 3 months back (you may want to adjust if yoiu really want 2 months)
dateparse("MMMM YYYY",[Date])=date(datetrunc('month', dateadd('month',-3,today())))
you can use it in filters or in calculations
Thanks
Jim - Tableau Visionary
