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.