Forum Discussion

jeyare's avatar
jeyare
Helper II
3 years ago
Solved

Select for Year when each year data represents diff column

Hi there,

I will be grateful for an idea of how to make a time (Year) filter from the data (Main Table), where the data for the corresponding year is stored in the columns:

Item1Item220152016201720182019202020212022
AAAAA        
BBBAA        
CCCBB        

 

My target:

1. I created a new "Year Table" with a single column (Year) and appropriate years data there (2015-2022) based on the Main Table columns.

2. I got stuck in creating a relation with the Main Table data (year defined by column), where:

Selection (slicer, measurements, ...) of the Year Table will get the exact Year from the Main Table.

Thx for your help.

 

J.