Formatting a date in a measure (DAX)

[Anonymous]

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 showing: Between 2020/05/30 12:09:42 AM

I want it to show:  Between 5/30/2020

"Between "&
(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()

[Chihiro]

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.

[aanyoti]

This worked for me, thanks!

[Anonymous]

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

[Chihiro]

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

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

[Anonymous]

I tried that but I got an error

[Chihiro · Accepted solution]

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"
    )

[Anonymous]

Yep got it to work now! thanks.