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"

     

     

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.