Forum Discussion

JLarkin's avatar
JLarkin
Frequent Visitor
3 years ago
Solved

Dynamic Title Switcher

Hi all,    I was hoping to get help with a dynamic title of month and year, like so:  This is currently made using the following two formulae:  Title - Selection = CONCATENATEX(     VAL...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi JLarkin 
    Please try

    Title - Selection =
CONCATENATEX (
    VALUES ( DATE_DIM[MNTH_NAME] ),
    DATE_DIM[MNTH_NAME],
    " & ",
    CALCULATE ( MAX ( DATE_DIM[MNTH_NUMBER] ) ), ASC
)

     

    Title =
IF (
    COUNTROWS ( VALUES ( 'DATE_DIM'[MNTH_NAME] ) ) = 3
        && COUNTROWS ( VALUES ( 'DATE_DIM'[QTR] ) ) = 1,
    MAX ( 'DATE_DIM'[QTR] ),
    [Title - Selection]
) & " "
    & SELECTEDVALUE ( 'DATE_DIM'[YR_NBR] ) & " - Total Sales Bookings"

     

     

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi JLarkin 
Please try

Title - Selection =
CONCATENATEX (
    VALUES ( DATE_DIM[MNTH_NAME] ),
    DATE_DIM[MNTH_NAME],
    " & ",
    CALCULATE ( MAX ( DATE_DIM[MNTH_NUMBER] ) ), ASC
)

 

Title =
IF (
    COUNTROWS ( VALUES ( 'DATE_DIM'[MNTH_NAME] ) ) = 3
        && COUNTROWS ( VALUES ( 'DATE_DIM'[QTR] ) ) = 1,
    MAX ( 'DATE_DIM'[QTR] ),
    [Title - Selection]
) & " "
    & SELECTEDVALUE ( 'DATE_DIM'[YR_NBR] ) & " - Total Sales Bookings"

 

 

  • mes0012's avatar
    mes0012
    Frequent Visitor
    2 years ago

    Thanks tamerj1  i've been scratching my head on something similar for a while, this worked perfectly.

    How would i go about layering in YTD? For example, if April - August are selected then return "YTD"?

    Many thanks,

    Matt.

    • tamerj1's avatar
      tamerj1
      Community Champion
      2 years ago

      Hi mes0012 

      Please elaborate further on your requirements. 

      • mes0012's avatar
        mes0012
        Frequent Visitor
        2 years ago

        Hi tamerj1 ,

        So i'm looking to build a dynamic title that breaks down as follows:

        - If singular month selected it appears as below

        - If two months are selected it appears in a list as below

        - If the relevant 3 months are selected for the qtr then return the financial qtr as below

        All of the above works perfectly using your original solution.

         

        The bit i'm struggling with is layering in "YTD" if all months are selected. I currently have it structured as below when all months are selected. Instead of a list of the months selected i want it to return "YTD".

        Hopefully this makes more sense! 

         

        Thanks,

        Matt.