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 dear collaborators!
I'd like to kindly ask for your help regarding the following: I have the below information and I would like to calculate the subtotals for A and B and then divide [(subtotal A) / (subtotal B)] to get the values per month (the highlighted table), as my aim is to plot these monthly values in a line chart to visualize the trend. The first criteria will be to filter the info out by date (month), but I also have some codes associated to more slicers. I have tried to work this out with no success (I'm quite new using PowerBi). Is there anyone that can guide me to solve this problem? Thanks in advance!
Solved! Go to Solution.
You can achieve this by rolling up the date to year month format, then creating a measure to perform the calculation:
Hi,
You could create the Month-Num column in your table as below :
Hi,
You could create the Month-Num column in your table as below :
Thank you for your alternative solution, MahyarTF! Much appreciatted!
You can achieve this by rolling up the date to year month format, then creating a measure to perform the calculation:
Thank you for your fast reply, dcrow5378!
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |