Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |