Forum Discussion

RH205's avatar
RH205
Helper I
1 year ago
Solved

Dynamic format %, Number, and Date

Hi all!    Question..what syntax does it need to show the correct "dd-mm-yyy" in the dynamic format option? decimal and percentage are fine, but the date is not..is there a solution?     ...
Need Help
  • v-aatheeque's avatar
    v-aatheeque
    1 year ago

    Hi  RH205 
    Just a quick reminder that the engineer has already shared the recommended syntax for displaying dates in the dd-mm-yyyy format using the FORMAT()  function in DAX.

    Example:

     

    FormattedDate = FORMAT('YourTable'[DateColumn], "dd-mm-yyyy")

    If the dynamic format option still isn't reflecting this as expected,

     

    feel free to share where you're applying it (e.g., card, matrix,) so we can assist further.

v-aatheeque's avatar
v-aatheeque
Community Support
1 year ago

Hi  RH205 
Just a quick reminder that the engineer has already shared the recommended syntax for displaying dates in the dd-mm-yyyy format using the FORMAT()  function in DAX.

Example:

 

FormattedDate = FORMAT('YourTable'[DateColumn], "dd-mm-yyyy")

If the dynamic format option still isn't reflecting this as expected,

 

feel free to share where you're applying it (e.g., card, matrix,) so we can assist further.

v-aatheeque's avatar
v-aatheeque
Community Support
1 year ago

Hi RH205


Just a quick reminder the provided  recommended DAX syntax to format dates as dd-mm-yyyy using the FORMAT () function:

 
FormattedDate = FORMAT('YourTable'[DateColumn], "dd-mm-yyyy")


If it's still not displaying as expected, please let us know where you're applying it (e.g., card, matrix, etc.)

so we can assist you further.