Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Formatting a date in a measure (DAX)

This should be simple but can't see how to format a date in a measure.  This measure works fine except it give me a date/time format. And all I want is a MM/DD/YYYY format:   Right now it is showin...
Need Help
  • Chihiro's avatar
    Chihiro
    7 years ago

    Works for me...

     

     

    Try...

    Measure =
"Between "
    & FORMAT (
        (
            CALCULATE (
                AVERAGEX ( prd_f_GW_Stats, prd_f_GW_Stats[TubeUsage1] ),
                FILTER ( prd_f_GW_Stats, prd_f_GW_Stats[LRFlag] = "NLR" )
            )
                - CALCULATE (
                    AVERAGEX ( prd_f_GW_Stats, prd_f_GW_Stats[TubeUsage1] ),
                    FILTER ( prd_f_GW_Stats, prd_f_GW_Stats[LRFlag] = "LR" )
                )
        )
            / CALCULATE (
                AVERAGEX ( prd_f_GW_Stats, prd_f_GW_Stats[Burn Rate] ),
                FILTER ( prd_f_GW_Stats, prd_f_GW_Stats[LRFlag] = "LR" )
            )
            + TODAY (),
        "M/d/yyyy"
    )
Chihiro's avatar
Chihiro
Icon for Solution Sage rankSolution Sage
7 years ago

Instead of applying format in the measure formula, you could apply format in model.

 

With measure highlighted.

 

Go to "Modeling" tab, and use "Format:" drop down. Apply formatting of your choice.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    That doesn't work because this measure is part text and part date

    • Chihiro's avatar
      Chihiro
      Icon for Solution Sage rankSolution Sage
      7 years ago

      Ah I missed that part. Then nest the date portion in FORMAT()

      Ex: FORMAT(TODAY(),"M/d/yyyy")

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I tried that but I got an error

  • aanyoti's avatar
    aanyoti
    Icon for Helper I rankHelper I
    5 years ago

    This worked for me, thanks!