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 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.  

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.

     

     

2 Replies

  • 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.