Forum Discussion
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 figerout the DAX formulas.
You have it solved here: http://community.powerbi.com/t5/Desktop/Divide-summarized-column-by-another-summarized-column/m-p/470127#M218415
just create a new mesure and use the DIVIDE() function. Seems that this is all you will need
5 Replies
garvicasasHelper I
You have it solved here: http://community.powerbi.com/t5/Desktop/Divide-summarized-column-by-another-summarized-column/m-p/470127#M218415
just create a new mesure and use the DIVIDE() function. Seems that this is all you will need
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]) )/60but 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