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.
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''
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 |
---|---|
107 | |
94 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |