Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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.

 

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

 

Calculate two columns.PNG

1 ACCEPTED SOLUTION
garvicasas
Helper I
Helper I

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

View solution in original post

5 REPLIES 5
garvicasas
Helper I
Helper I

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
Not applicable

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? 

concat.PNG

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
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.