Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I have a table with the sales of products by month, the user wants to select a Quartely month (March, June, September, December) then the PBI must:
a) Get the Sales amount for the last 4 quarters and summarize it by product.
b) Do the same calculation with other quarter
c) compare both amounts
By Example:
a) the user select from a slicer September 2023, then I need summarize the amounts of (September 2023, June 2023, March 2023 and December 2022)
b) From a second Slicer the user select June 2023, then I need get the amount of June 2023, March 2023, December 2022 and Septemner 2022.
c) show both amounts with the variations by products.
This is an example of my table only with 1 product:
Product | Month | Amount |
GG-001 | Jan-22 | 6,759 |
GG-001 | Feb-22 | 6,323 |
GG-001 | Mar-22 | 5,915 |
GG-001 | Apr-22 | 5,534 |
GG-001 | May-22 | 5,177 |
GG-001 | Jun-22 | 4,843 |
GG-001 | Jul-22 | 4,531 |
GG-001 | Aug-22 | 4,239 |
GG-001 | Sep-22 | 3,965 |
GG-001 | Oct-22 | 3,710 |
GG-001 | Nov-22 | 3,470 |
GG-001 | Dec-22 | 3,247 |
GG-001 | Jan-23 | 3,037 |
GG-001 | Feb-23 | 2,841 |
GG-001 | Mar-23 | 2,658 |
GG-001 | Apr-23 | 2,487 |
GG-001 | May-23 | 2,326 |
GG-001 | Jun-23 | 2,176 |
GG-001 | Jul-23 | 2,036 |
GG-001 | Aug-23 | 1,905 |
GG-001 | Sep-23 | 1,782 |
GG-001 | Oct-23 | 1,667 |
GG-001 | Nov-23 | 1,559 |
In the example above thi will be the results:
QT | Sum Last 4 Qt | Note |
Sep-23 | 9,863 | Sum (Sep23, Jun23, Mar23, Dec22) |
Jun-23 | 12,046 | Sum (Jun23, Mar23, Dec22,Jun22) |
Variation | (2,183) |
Can you please help me?
Solved! Go to Solution.
Hi,
PBI file attached.
Hope this helps.
thank you.. it works for me.. I really appreciate your help!
It works.. thank you very much!!
You are welcome.
thank you.. it works for me.. I really appreciate your help!
Worked perfect!!. thank you!!. I reaaly appreciatte your help!!.
User | Count |
---|---|
123 | |
96 | |
89 | |
73 | |
64 |
User | Count |
---|---|
138 | |
115 | |
111 | |
98 | |
95 |