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"

     

     

ShahabHoghooghi's avatar
ShahabHoghooghi
Frequent Visitor
3 years ago

Hi,

Try This Dax Code Instead:

 

Title - Selection =

VAR __MonthOrder = LOOKUPVALUE(DATE_DIM[MNTH_NUMBER], DATE_DIM[MNTH_NAME], SELECTEDVALUE(DATE_DIM[MNTH_NAME]))

RETURN

CONCATENATEX(
    VALUES(DATE_DIM[MNTH_NAME]),
    DATE_DIM[MNTH_NAME],
    " & ",
    __MonthOrder,
    ASC)