Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Divide summarized column by another summarized column

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 figer...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
garvicasas
Helper I
8 years ago

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

  • garvicasas's avatar
    garvicasas
    Helper I
    8 years ago

    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''

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you . Joining worked like charm!