the calculation below works....
IF min([Invoice Logged Date New])<=[Start_Date]
min(DATEDIFF('day',[Invoice Logged Date New],[Start_Date])>=1)
and does give values if the start_date parameter is changed. On the Dashboard 1, you have the Date_Selection_Para showing which does nothing on this sheet. I added Start_Date as the parameter.
I'm not sure if it is giving you the values you want, but it does give you values
I have Tableau 10.3 so you may not be able to open the attached workbook.
If condition Issue.twbx 1.4 MB
Same i have used Min Function but Min function min([Invoice Logged Date New])
Will give me Count of previous month,but I need count change what ever date I select.
Please let me know how to handle that use.
Thanks in advanced
Yes I have to calculate with Start_date only,what ever day I select in Start _date parameters Selection my count should changed.
The value of [Invoices Open on 1st date] does change using Shin's formula and changing the values of the parameter of start_date.
So how to handle this issue.
As date parameters select value change the count value also change.
I don't understand your recent issue.
If you posted new one already, Could you close the thread with marking either of answer as correct.