Overlapping Date Period Labels

[garynorcrossmmc]

Hi all,

I am trying to create a column labeled '12 Months', '18 Months' and '24 Months' according to which values in this table have a 1 or 0 in the columns labeled the same way:

The column would be used as a slicer in the report for a user to select a time period.  I have tried using IF, SWITCH and other methods but cannot figure out how to do this.  

[samdthompson · Accepted solution]

Hello, couple of ways to do it. This is probably going to be the easiest:

1. Make a unconnected Table with the names of the Time period you want

2. Reference the time period names from the new table in a calculation like this:

Value = 
IF(HASONEFILTER(Table[CalcType]),
    SWITCH(SELECTEDVALUE(Table[CalcType]),
        "12Months", [12MonthCalc],
        "18Months", [18MonthCalc],
        "24Months", [24MonthCalc]
    ),
   BLANK()
)

Any new ones need to be referenced in this calculation but its not a lot of work to do.

[Vlad_Machan]

Hello there, I need exactly this, but I'm not able to understand the solution properly... 😕 
Could you please explain it to me in a bit more detail?
The "Value" - it's measure?

And what is "Table" and the column [CalcType]? Is it the new disconnected table?
And which field do I use in the slicer?
Your help would be very much appreciated!
Thank you.