Thanks Doug.it cleared my doubt.So only Extract is the only option to use MAKEDATE.
There are usually other alternatives, including parsing and/or building a string to pass to the DATE() function.
1 of 1 people found this helpful
I originally have a live data source (Amazon Redshift)
I have replicated the workbook using an extract and
gives me what I am looking for (pls refer Searching for max date dynamically ), but in a live connection MAKEDATE is not an available option so I used DATE() as
IIF([NewDate]=DATE("01"+"/"+str([maxMonth])+"/"+str([maxYear])),[Claim Count],0), but this does not return the same results.
Your thoughts on this?
4 of 4 people found this helpful
Your approach is correct only, before comparing dates please make sure the output format of the [NewDate] field and write your comparable date logic accordingly.
Best way to avoid such confusion is change the setting of your workbook local according to your country.
For Ex.: If you are in India then I believe you are aware of India's date standard is dd-mm-yyyy.
Click on File -- Workbook Local -- More -- (Select English(India))
Now: Tableau will parse your date fields according to India standard then you can write your logic easily
other wise it will read the Date Time Setting according to your system.
Hope this will help you.