Skip navigation

6 Replies Latest reply on Jul 31, 2017 4:38 PM by Deepak Rai

Comparing Current month data with previous year's month data

Rupali jain Jul 31, 2017 3:30 PM

Hi Guys,

I'm creating a side to side bar graph of current month - year and I want it to compare with data of month of previous year. I created a calculated field for current month as :

IIF(DATETRUNC('month',[Date Loaded]) = DATETRUNC('month',TODAY()),'true','false') and added in the Filter shelf.

How do I add the filter for previous year data? For example, current month is July 2017, what is formula to find data for July 2016 such that I can this to the filter shelf and it helps to compare data.

Thank you in advance.

1. Re: Comparing Current month data with previous year's month data

Deepak Rai Jul 31, 2017 3:30 PM (in response to Rupali jain)

IF Year(data Loaded)=Year(Today())-1 and month(dataloaded)=Month(Today()) Then True else false end.
Won't this work?
Like Show 0 Likes(0)

Actions
2. Re: Comparing Current month data with previous year's month data

Rupali jain Jul 31, 2017 3:38 PM (in response to Deepak Rai)

Hi Deepak,

Thank you for replying. This formula doesn't help. If I add this my worksheet becomes blank.

Thank you
Like Show 0 Likes(0)

Actions
3. Re: Comparing Current month data with previous year's month data

Deepak Rai Jul 31, 2017 4:02 PM (in response to Rupali jain)

Put This in Rows
IF MONTH([Dataloaded]) = MONTH(TODAY())
AND DAY([Dataloaded]) <= DAY(TODAY())
THEN [Sales]
END

Drag Year (dataloaded) to Columns and Filter for 2017 and 2016 only.
Thanks
Deepak
Like Show 0 Likes(0)

Actions
4. Re: Comparing Current month data with previous year's month data

Rupali jain Jul 31, 2017 4:25 PM (in response to Deepak Rai)

it doesn't work!
Like Show 0 Likes(0)

Actions
5. Re: Comparing Current month data with previous year's month data

Deepak Rai Jul 31, 2017 4:36 PM (in response to Rupali jain)

This is how I plot July 2016 and July 2015 Profits from Superstore data.
Like Show 0 Likes(0)

Actions
6. Re: Comparing Current month data with previous year's month data

Deepak Rai Jul 31, 2017 4:38 PM (in response to Rupali jain)

This is the data
Like Show 0 Likes(0)

Actions

Go to original post

More Like This