Divide summarized column by another summarized column

[Anonymous]

Could you please help me out to calculate two summarized columns. I have attached screenshot and pbix file for the same. THank you so much in advance. Since I am very new in powerbi, i couldn't figerout the DAX formulas.

https://app.powerbi.com/groups/me/reports/27a39b38-d2ce-4efa-acc5-90c7be2eb65f?ctid=6e747d17-46a5-45...

[garvicasas · Accepted solution]

You have it solved here: http://community.powerbi.com/t5/Desktop/Divide-summarized-column-by-another-summarized-column/m-p/47...

just create a new mesure and use the DIVIDE() function. Seems that this is all you will need

[Anonymous]

Thank you for pushing me. I saw that post but did not realize this was that easy. Now i am able to calculate the desired column with 

Avg Stay TIme = 
DIVIDE(
	SUM('Sheet1'[Duration Seconds]),
	DISTINCTCOUNT('Sheet1'[BadgeID])
)/60

but how can i concatnate this value that add "minute" with the numeric value i got? 

[garvicasas]

try modifying the column or adding one with [your result] & 'minute'

the & thing it's like the + in some programming lenguages like java, you can concatenate different values or text

[Anonymous]

Thank you . Joining worked like charm!

[garvicasas]

Although that in mathematics it's stetically better to use ' so 5 minutes it's 5', 5 seconds it's 5'', and 5 minutes with 5 seconds, 5'5''