Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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
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?
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
Thank you . Joining worked like charm!
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''
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |