Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hello, I'm looking to add a new column for conversion rate, so divide by count & the column total for specific groups. For Ex. I have WA and it's Successful Installs is 43 & the total is 139 in April. I want a new column that says 31%? Like CA in April it has 216 successful and 508 total, so the new column would say 42%!
Thank you for helping me!
Solved! Go to Solution.
Hi,
Download the PBI file from here.
Hope this helps.
Based on your example do you want a column with this percentage for each month, for totals, or both?
Do you know how I can solve my problem? @Anonymous
Hi,
So you want that calculation for each month but only for the row which reads as Successful installs. If i am correct, then share the link from where i can download your PBI file.
Hello @Ashish_Mathur , I want that calculation for each month of each group (Nationwide, CA, WA, Other) only for the row which reads as Successful installs, defective installs, no installs, and service
Hi,
Share the link from where i can download the PBI file.
@Ashish_Mathur Hello Ashish, are you able to resolve my problem? I am really appreciative!
Hi,
That is not a downloadable PBI file.
Hi,
That takes me to a sign-in page. Upload the file to Google Drive and share the download link here.
@Ashish_Mathur https://drive.google.com/file/d/1CEiyreLeQtbUyS0_2oSOUCA8T38Jyenp/view?usp=sharing
okay this should work!
Hi,
Download the PBI file from here.
Hope this helps.
Thank you!
You are welcome.
@Ashish_Mathur How do I share you a downloadable link? I'm new to Power BI , sorry!
Hi, I want a column with a percentage for both pls! Ex. Looking at Nationwide in March for 'Successful' a column beside it would be 8/13=62%, etc for april and may... and then for Total there would be a column beside it being 519/1317= 38%.
Thank you so much if you can help!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
User | Count |
---|---|
94 | |
90 | |
83 | |
76 | |
49 |
User | Count |
---|---|
145 | |
141 | |
109 | |
69 | |
55 |