Exclude last month from data set

0 votes

How to always show data by excluding the most recent month?

May 22 in Tableau by Peter
23 views

1 answer to this question.

0 votes
Hi Peter,

Use a condition as below and statements to perform data

IF MONTH([Order Date])!= MONTH({MAX([Order Date])}) AND YEAR([Order Date])= YEAR({MAX([Order Date])}) THEN "........"
ELSE ......" END

OR

IF DATEDIFF('month',[Order Date], {MAX([Order Date])})>0 THEN "....." ELSE "......." END

Hope it helps!
answered May 22 by Cherukuri
• 32,260 points

Related Questions In Tableau

0 votes
1 answer

How to calculate weekly average from daily data?

You can create these calculated fields: Unique Weeks ...READ MORE

answered Jun 26, 2018 in Tableau by Atul
• 10,240 points
495 views
0 votes
1 answer

Performing automatic read and update data source from a web data connector

Dashboard on Tableau Public can only be ...READ MORE

answered Aug 27, 2018 in Tableau by Atul
• 10,240 points
37 views
0 votes
1 answer

Replacing Data Source from one Server to Another

I did something similar to it For ...READ MORE

answered Sep 19, 2018 in Tableau by Naruto
• 710 points
47 views
0 votes
1 answer

How to get past N months date from data source?

Hi, this is a one solution to your ...READ MORE

answered Mar 1 in Tableau by Cherukuri
• 32,260 points
76 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
2,376 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
117 views
+2 votes
1 answer
0 votes
1 answer

last n days transactions data from dataset

Hey,  You can create a calculated column or ...READ MORE

answered May 22 in Tableau by anonymous
• 32,260 points
29 views
0 votes
1 answer

How to set Actions from sheet to Dashboards

Hey, The below Filter can be used to navigate from ...READ MORE

answered Feb 28 in Tableau by Cherukuri
• 32,260 points

edited Feb 28 by Cherukuri 43 views