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 have following data set. When I put into a visual and report by quarter the quantity and rate fields are summed (refer graph 1).
I want the quantity to sum by quarter and the rate to display as at quarter end. For example December 2022 quarter Quantity = 45 and Rate = 30% (refer graph 2). Can somebody please help with a measure to display the rate at the end of the quarter in a graph.
Date | Quantity | Rate |
31-Dec-22 | 20 | 30% |
30-Nov-22 | 15 | 5% |
31-Oct-22 | 10 | 5% |
30-Sep-22 | 55 | 10% |
31-Aug-22 | 80 | 25% |
31-Jul-22 | 40 | 25% |
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
Thankyou, much appreciated
You are welcome.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |