Forum Discussion

garynorcrossmmc's avatar
garynorcrossmmc
Advocate IV
5 years ago
Solved

Overlapping Date Period Labels

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 w...
Need Help
  • samdthompson's avatar
    samdthompson
    5 years ago

    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.

     

     

samdthompson's avatar
samdthompson
Memorable Member
5 years ago

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's avatar
Vlad_Machan
New Member
2 years ago

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.