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.
Hi all,,
I need to turn the data in table into a chart and I cannot use the measure on the legend or axis on chart
Avg = var dayNo=INT(AVERAGE('Group Query'[mins])/1440)
var hourNo=INT(MOD((AVERAGE('Group Query'[mins])),1440)/60)
var minuteNO=MOD(MOD((AVERAGE('Group Query'[mins])),1440),60)
var days=if(dayNo>1,dayNO&" Days ",if(dayNo=1,dayNO&" Day "))
var hrs=if(hourNo,FORMAT(hourNo,"#0")&" Hrs ",if(hourNo=1,FORMAT(hourNo,"#0")&" Hr "))
var mins=if(minuteNO>1,FORMAT(minuteNo,"#0")&" Mins",if(minuteNO=1,FORMAT(minuteNo,"#0")&" Min",if(minuteNO=0,"")))
return CONCATENATE(days,CONCATENATE(hrs,mins))
Solved! Go to Solution.
Hi @Gokul
Create measures
dayNo = INT(AVERAGE('Group Query'[mins])/1440) hourNo = INT(MOD((AVERAGE('Group Query'[mins])),1440)/60) minuteNO = MOD(MOD((AVERAGE('Group Query'[mins])),1440),60)
Then create a column
column =
var days = if([dayNo]>1,[dayNO]&" Days ",if([dayNo]=1,[dayNO]&" Day ")) var hrs = if([hourNo],FORMAT([hourNo],"#0")&" Hrs ",if([hourNo]=1,FORMAT([hourNo],"#0")&" Hr ")) var mins2 = if([minuteNO]>1,FORMAT([minuteNo],"#0")&" Mins",if([minuteNO]=1,FORMAT([minuteNo],"#0")&" Min",if([minuteNO]=0,""))) Return CONCATENATE(days,CONCATENATE(hrs,mins2))
Best Regards
Maggie
I need to turn the data in table into a chart and I cannot use the measure on the legend or axis on chart
My Measure:
AvgTurnaroundTime= var dayNo=INT(AVERAGE('Group Query'[_mins])/1440)
var hourNo=INT(MOD((AVERAGE('Group Query'[mins])),1440)/60)
var minuteNO=MOD(MOD((AVERAGE('Group Query'[mins])),1440),60)
var days=if(dayNo>1,dayNO&" Days ",if(dayNo=1,dayNO&" Day "))
var hrs=if(hourNo,FORMAT(hourNo,"#0")&" Hrs ",if(hourNo=1,FORMAT(hourNo,"#0")&" Hr "))
var mins=if(minuteNO>1,FORMAT(minuteNo,"#0")&" Mins",if(minuteNO=1,FORMAT(minuteNo,"#0")&" Min",if(minuteNO=0,"")))
return CONCATENATE(days,CONCATENATE(hrs,mins))
Hi @Gokul
Create measures
dayNo = INT(AVERAGE('Group Query'[mins])/1440) hourNo = INT(MOD((AVERAGE('Group Query'[mins])),1440)/60) minuteNO = MOD(MOD((AVERAGE('Group Query'[mins])),1440),60)
Then create a column
column =
var days = if([dayNo]>1,[dayNO]&" Days ",if([dayNo]=1,[dayNO]&" Day ")) var hrs = if([hourNo],FORMAT([hourNo],"#0")&" Hrs ",if([hourNo]=1,FORMAT([hourNo],"#0")&" Hr ")) var mins2 = if([minuteNO]>1,FORMAT([minuteNo],"#0")&" Mins",if([minuteNO]=1,FORMAT([minuteNo],"#0")&" Min",if([minuteNO]=0,""))) Return CONCATENATE(days,CONCATENATE(hrs,mins2))
Best Regards
Maggie
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |