Forum Discussion

enlamparter's avatar
enlamparter
Helper I
9 years ago
Solved

Dynamic Text Won't Update

I'm trying to use a measure to create a title for my page that updates based on the date selected in my slicer. My original measure updated perfectly fine, but my results looked funny (i.e. January 2...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi enlamparter,

     

    If you use the function "format", then the function "month" isn't needed. You could try this:

    New Selected Period =
CONCATENATE (
    FORMAT ( FIRSTDATE ( 'Calendar'[Date] ), "mm" ) & ", ",
    YEAR ( FIRSTDATE ( 'Calendar'[Date] ) )
)

    Or try this with Anonymous' idea:

    Selected Period =
FORMAT ( FIRSTDATE ( 'Calendar'[Date] ), "mm" ) & ", "
    & YEAR ( FIRSTDATE ( 'Calendar'[Date] ) )

    Best Regards!

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Hi enlamparter,

 

If you use the function "format", then the function "month" isn't needed. You could try this:

New Selected Period =
CONCATENATE (
    FORMAT ( FIRSTDATE ( 'Calendar'[Date] ), "mm" ) & ", ",
    YEAR ( FIRSTDATE ( 'Calendar'[Date] ) )
)

Or try this with Anonymous' idea:

Selected Period =
FORMAT ( FIRSTDATE ( 'Calendar'[Date] ), "mm" ) & ", "
    & YEAR ( FIRSTDATE ( 'Calendar'[Date] ) )

Best Regards!

Dale

enlamparter's avatar
enlamparter
Helper I
9 years ago

Thanks Dale, taking out the "month" function worked!