cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper IV

## How Get the amount by product only of Quarter months (March, June, September, December)

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)

2 ACCEPTED SOLUTIONS
Super User

Hi,

PBI file attached.

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper IV

thank you.. it works for me.. I really appreciate your help!

6 REPLIES 6
Super User

Hi,

PBI file attached.

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper IV

It works.. thank you very much!!

Super User

You are welcome.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

see attached.

Helper IV

thank you.. it works for me.. I really appreciate your help!

Helper IV

Worked perfect!!. thank you!!. I reaaly appreciatte your help!!.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.