Use the same column for different date periods (non-numerical)

[anmdf]

Hi,

So i have the table below to say how many months the description is, and I have a slicer for two periods

Year	Description	Value
2021	ABC	18 months
2021	BCD	12 months
2020	ABC	7 months
2020	BCD	8 months

The value may be different for the same description but different period (e.g. in 2021 ABC is 16 months, in 2020 ABC is 18 months, etc.). It's not calculated, but kind of like a policy that could change over time.

Is there a way to show two columns of "value" that is dependent on the two period slicers? For example, if I change Period A to a certain period, only the Period A value will change. I was able to do this with numerical values by using CALCULATE and USERELATIONSHIP, but I'm a bit lost as to how to do it for text values.

Sample:

Slicer 1 - Period A (2018, 2019, 2020, 2021) = selected 2020

Slicer 2 - Period B (2018, 2019, 2020, 2021) = selected 2021

Description	Period A value	Period B value
ABC	7 months	18 months
BCD	8 months	12 months

[BA_Pete · Accepted solution]

Hi @anmdf ,

Can you share the measure calculation you used for the nnumerical values to work please?

In theory, it should work fine for text values using a MAX() function or similar instead of SUM().

I'm assuming you're using a role-playing dimension setup for the two year slicers?

Pete

[anmdf]

Hi @BA_Pete ,

Thank you for your response. The measure for numerical values goes like this:

Measure = CALCULATE([Amount], USERELATIONSHIP('Calendar - Period A'[Date], Database[Date])

MAX() function worked. Thank you!