Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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()
Solved! Go to 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" )
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.
This worked for me, thanks!
That doesn't work because this measure is part text and part date
Ah I missed that part. Then nest the date portion in FORMAT()
Ex: FORMAT(TODAY(),"M/d/yyyy")
I tried that but I got an error
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" )
Yep got it to work now! thanks.
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |