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

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.

 

tamerj1's avatar
tamerj1
Community Champion
2 years ago

mes0012 

Try to wrap the formula with 

IF (

ISFILTERED ( 'Table'[Month] ),

'Original formula',

"YTD"

)