KNOWLEDGE BASE

Indexation Of A Time-Series Line Graph Using The First Month's Value As 100


Published: 09 Dec 2020
Last Modified Date: 10 Dec 2020

Question

How to calculate the indexation of a measure and set the first month as 100.

Environment

  • Tableau Desktop

Answer

Use the calculation is like the following:

{ FIXED YEAR([Order Date])*100 + MONTH([Order Date]):SUM([Sales])}
/
{SUM(IF YEAR([Order Date])*100 + MONTH([Order Date])={MIN(YEAR([Order Date])*100 + MONTH([Order Date]))} THEN [Sales] END)}
*100
Did this article resolve the issue?