4 Replies Latest reply on Oct 31, 2018 4:41 PM by Shinichiro Murakami

Latest Month Units

satya kanth achanta tishan Oct 31, 2018 10:28 AM

I need to calculate "Latest Month Units" but for that the formula is :

IF DATEDIFF('month',DATETRUNC('month',[Order Date]),{MAX(DATETRUNC('month',[Order Date]))})=0
THEN [Units]
END

But in my source Sheet (Excel) I have Year, Month and Quarter columns I don't have Order Date.

How can I calculate Latest Month Units ?

Thank You

1. Re: Latest Month Units

Jim Dehner Oct 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.
Like Show 0 Likes(0)

Actions
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>
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
4. Re: Latest Month Units

Shinichiro Murakami Oct 31, 2018 4:41 PM (in response to satya kanth achanta tishan)

Please attach sample mocked up data.

Thanks,
Shin
Like Show 0 Likes(0)

Actions

Tableau Community Forums