-
1. Re: Latest Month Units
Jim DehnerOct 31, 2018 10:33 AM (in response to satya kanth achanta tishan)
Hi you can convert the year and month into a date
depending on the data type - if they are numbers us
MAKEDATE(year,month,day) and use 01 for the day
if they are strings you need to concatenate the year month day (again 01 for day) into a string the use
DATE(" insert date here ")
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
2. Re: Latest Month Units
satya kanth achanta tishan Oct 31, 2018 3:32 PM (in response to Jim Dehner)Do you want me to change all of them to integer type?
String,string,integer is the error it’s giving
On Wed, Oct 31, 2018 at 4:01 PM Jim Dehner <tableaucommunity@tableau.com>
-
3. Re: Latest Month Units
satya kanth achanta tishan Oct 31, 2018 3:32 PM (in response to Jim Dehner)If I change it to integer then it’s valid but value is coming Null
-
4. Re: Latest Month Units
Shinichiro MurakamiOct 31, 2018 4:41 PM (in response to satya kanth achanta tishan)
Please attach sample mocked up data.
Thanks,
Shin