I am not able to see start date calculation in parameter.
how to make visible in parameter when workbook opens start date
Note : management cut off date is (int)parameter (0,10,80,120) for above calculations
Run date refers to user selection date parameter.
Please suggest how to get in start date into parameter.
@Vicky P
Your problem is that you can't use the same parameter that you are trying to assign into your FIXED calc (it is like a circular reference).
You may use:
{
(DATE(DATETRUNC('day',
max(DATE(DATEADD('day',-[Management Cutoff(days)],DATETRUNC('day',{MAX([Run Date])})))))))
}
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
