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.
Hello, I hope that I can get a bit of help. I have two columns in my DATA table and I'm trying to divide one by the other to give me a percentile output.
It's a simple call booking table. Ideally, I would like to see a percentage column which shows calls divided by booked_call for any given day and/or month.
Both calls and booked_calls are expressed in dd: mm:yyyy hh: mm: ss.
DATA[calls] is the first column and DATA[booked_calls] is the other.
Thanks for your help in advance.
Solved! Go to Solution.
Hi Eric,
Thanks for your message. Since I have date_table, I managed to get the percentages of the "calls" over the "booked_calls" using the following formula:
Percentage = DIVIDE([count of calls],[count of booked_calls])*100
Best
Q
@qs wrote:
Hello, I hope that I can get a bit of help. I have two columns in my DATA table and I'm trying to divide one by the other to give me a percentile output.
It's a simple call booking table. Ideally, I would like to see a percentage column which shows calls divided by booked_call for any given day and/or month.
Both calls and booked_calls are expressed in dd: mm:yyyy hh: mm: ss.
DATA[calls] is the first column and DATA[booked_calls] is the other.
Thanks for your help in advance.
It is not quite clear for me. Could you share any sample data and expected output?
In substance, I would like to calculate the ratio of "Count of calls" over "Count of booked_calls" expressed in percentage for each given month.
Then you'll have to split those two column into individual tables, convert the selected column to date type.
booked_calls = SELECTCOLUMNS(yourTable,"booked_call",yourTable[booked_call]) calls = SELECTCOLUMNS(yourTable,"call",yourTable[calls])
Create a calendar table.
calendar = CALENDAR("2017-01-01","2017-12-31")
The create proper relationship
Then just create a measure as
prec = DIVIDE(COUNT(booked_calls[booked_call]),COUNT(calls[call]))
Hi Eric,
Thanks for your message. Since I have date_table, I managed to get the percentages of the "calls" over the "booked_calls" using the following formula:
Percentage = DIVIDE([count of calls],[count of booked_calls])*100
Best
Q
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 |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |