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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Check the icon next to the measure/column.  Does it look like a calculator or a box with Fx in it?  I'm wondering if you have created a calculated column by mistake.

  • enlamparter's avatar
    enlamparter
    Helper I
    9 years ago

    It's a calculator! :/

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Ok, try dropping the concatinate formula and instead simply make use of the & symbol.  Does this improve your outcome?