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.
Hi all!
I have the table "C&R BI" with the total of invoices done in each month and I want to add a column to obtain the percentage of Credit & Rebills done per month by my team, which I have in another table. So, basically, I need to divide the total of C&R done per Total of invoices. Problem is that I don't have the total per month of C&R done.
In table "C&R BI" I have the total invoiced per month, with the following columns, as an example:
Month/Year | Total invoiced
January 2018 | 300000
In another table, named "C&R Report", I have a list for each C&R done with the month in each line. It would be as follow:
Month/Year | Count
January 2018 | 1*
*The "1" represents that it's a C&R, which will help with the SUM.
I have also a Date dimension table.
How can I add a column to do that calculation? Get the total of C&R per month and divide it per Total invoiced.
My Excel mind thought in a SUMIF, but I found that it's not available in PowerBI (or I don't know how it's the code).
Thanks for your help!
Solved! Go to Solution.
Hi, thanks for your reply and sorry for the delay, I was very busy at work 😞
I was able to solve it with the below formula that I'd found on another site:
Can you show us your model? Are these two tables linked? To which table are you adding the column?
Thanks,
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi, thanks for your reply and sorry for the delay, I was very busy at work 😞
I was able to solve it with the below formula that I'd found on another site:
Hi @sconconi , I would start a new post. Nathaniel
Proud to be a Super User!
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |