Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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!!.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
81 | |
70 | |
49 |
User | Count |
---|---|
143 | |
124 | |
107 | |
60 | |
55 |