Creating calculate fields for year difference

0 votes
How to calculate difference of measure values using date column?. I want to find difference of profit between 2015-2016.
May 22 in Tableau by cherry
27 views

1 answer to this question.

0 votes

Hey cherry,

Drop Date field and dimension and measure to find the difference.

Use the Add quick calculation to find the difference across the table.

Right click on your measure field and Go to Add quick calculation and select Difference.

If you want to show vertical difference then right click on the field and go to Compute using and change to the table (down).

To convert into % drop the same measure again and follow the same above steps, 

Go to Edit quick calculation and select the calculation type as the percent difference from and select ok.

Hope it helps.

answered May 22 by anonymous
• 28,360 points

Related Questions In Tableau

0 votes
1 answer

How to change months for a calendar year

Hey, you can try this & Change ...READ MORE

answered Apr 20, 2018 in Tableau by QueenBee
• 1,810 points
25 views
0 votes
1 answer

Creating a calculated field for summing up the values

Well you can use this in your ...READ MORE

answered May 17, 2018 in Tableau by Atul
• 5,530 points
45 views
0 votes
1 answer

How to create a bar graph for two fields with same value?

I believe you want to have something ...READ MORE

answered May 28, 2018 in Tableau by Atul
• 10,240 points
46 views
0 votes
1 answer

How can I calculate current 1 year in Tableau?

A quick solution to this would be ...READ MORE

answered Aug 17, 2018 in Tableau by Atul
• 5,530 points
40 views
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
92 views
0 votes
1 answer

How to calculate profit when cost and revenue are in same column?

You can create the following calculated fields: Profit: SUM(IIF([account_category] ...READ MORE

answered Apr 10, 2018 in Tableau by Atul
• 5,530 points
82 views
0 votes
1 answer

Creating a calculated field with LOD expression

Go ahead and try the following three ...READ MORE

answered Apr 20, 2018 in Tableau by Atul
• 5,530 points
113 views
0 votes
1 answer

Calculation issue: Distinct sum in Tableau

SUM( { FIXED [Brand], [Market]: AVG(Target) } ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 10,240 points
2,702 views
0 votes
1 answer

How to find first n months profit/sales for a given year

Hi Sindhu, You can use Calculated field to ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 28,360 points
29 views
0 votes
1 answer

Format the values in fields for label

Hi, You can format a field by right click on ...READ MORE

answered Apr 1 in Tableau by Cherukuri
• 28,360 points
15 views