---
schema_version: "1"
id: e0efe9b1070429f76ba7f1cddbd349e7caf2f36e0926a7330f11ed18224afd7a
title: Create Custom Measure Relationships in Your Tableau Data Story
collection: tableau
version: current
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/current/en-gb/online/data_stories_relationship_story.md
canonical_url: https://help.tableau.com/current/online/en-gb/data_stories_relationship_story.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 460de13987078db35a150bf27bc71839544a2e4b6d2e1e1d9c434f90f9b2ca49
description: Feature retired.
---
[Skip to main content](#main-content)

# Create Custom Measure Relationships in Your Tableau Data Story

**Important changes for Tableau Data Stories**

Tableau Data Stories were retired in Tableau Desktop, Tableau Cloud and Tableau Server in January of 2025 (2025.1). With advances in natural language technologies, we're developing an improved interface that will make it easier to ask questions of your data and stay on top of changes. For more information, see [How Tableau Pulse powered by Tableau AI is Reimagining the Data Experience](https://www.tableau.com/en-gb/blog/tableau-pulse-and-tableau-ai).

You can create a relationship story in your Tableau Data Story to see how data compares to another set of data. To build a relationship story, you must have at least two measures and one dimension. Data that you'd like to compare is often grouped into one column of data named something such as "Year" or "Month", with values such as "2022" or "March".

You can [Create a Simple Calculated Field](https://help.tableau.com/current/pro/desktop/en-gb/calculations_calculatedfields_formulas.htm) to separate "2022" from "2021" (or March from February) so that you can compare the two time periods in a relationship story.  
  

1. Start in the sheet that you want to use in your Data Story.
2. Click Analysis and select Create a Calculated Field.
3. Create a calculated field such as "Current Period".  
      
    ![A calculated field that reads: If DATETRUNC (‘year’, \[Year\])= {MAX(DATETRUNC(‘year’, \[Year\]))} THEN \[Number of Records\] END](Img/data_stories_calcfield_current.png)

> [!TIP]
> 
> Follow the structure of the calculated field shown here, but substitute your own dimension or measure names (orange text).  

1. Create a calculated field such as "Previous Period".  
      
    ![A calculated field that reads: If DATETRUNC (‘year’, \[Year\])= DATEADD(‘year’, -1, {MAX(DATETRUNC(‘year’, \[Year\]))}) THEN \[Number of Records\] END](Img/data_stories_calcfield_previous.png)

1. Drag the new measures onto the Detail mark.
2. From your dashboard, click on the story and add the two new measures into your Data Story.  
      
    ![Data Story dialog box open to the Field tab with available dimensions and measures.](/tableau/current/en-gb/online/en-gb/Img/data_stories_calcfield_addnew.png)

1. From your dashboard, click the Settings icon in the top-left corner of your Data Story object.
2. In the Data Story dialog box, click the Relationships tab.
3. Set up a relationship story with the two custom measures.  
      
    ![The Data Story settings dialog box opens to the Relationships tab. The Current/Most Recent vs Previous Period box is ticked. The related measures are SUM (Previous Period) and SUM (Current Period).](/tableau/current/en-gb/online/en-gb/Img/data_stories_set_relationship.png)

1. Click Save.

Your story now writes sentences that compare the custom measures.