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,
I'm new in Power BI, and I have tried so many functions, but none of them return me the right value.
I have a table
Product | Amount | Start Date |
A | 100 | 01-01-2019 |
B | 200 | 01-01-2020 |
B | 250 | 01-05-2019 |
C | 400 | 15-03-2020 |
I would like to have the following:
SUM of the Product which are between 01-01-2019 and 01-01-2020, so A=100 , B =450, C is not in the list.
After that I would like to divide the product sum with the Total sum of the products in the mentioned time range, so:
100/550 and 450/550 what can gives me a percentage of the product distribution.
I have part success, but the hardest thing for me is divide it in a right time range.
Please help me, I would be appreciate!
Thanks,
D.
Hi Dexter
Please consider this solution
Drag the date to a slicer visual
Drag the product and sum amount to a table visual
Now drag the amount to the table visual again. So you have product, amount, amount.
Right click on the second amount and select Show value as > Percent of grand total.
Use the date slicer to select a date range and the totals and % should display accordingly.
Hi Speedramps,
Thanks for this solution, but this is only one step in my task, after this step I need to separate with another dates and additional products as well, that's why I need a measure or extra column to the dataset.
Regards,
Dexter
Hi again Dexter
Hope you get a solution from someone.
Sorry I am struggling to understand the scenario. If you don’t get an answer then please elaborate on the exercise.
Yes, I have found thank you
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |