Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gvladoxyz
Regular Visitor

Sales prediction according to average price for previous / last 3 months

Dear PBI friends

I am struggling with problem for a weeks

Need to calculate prediction sales in value (€) according average price previous 3 months
See attached table ( data table - left , desired table -right)

PBI comunity 2023-04-01.jpg

How work with such averages in dax or /and  query.
Excel file for better understanding 
Thanks in advance
Here is the data table

MonthProductSales €Sales pcsAVG priceSales p3m €Sales p3m pcsAVG price p3m (€/pcs) Plan pcs
          
          
          
2023-01-01Product A100200           0,50000,00  
2023-02-01Product A300200           1,501002000,50  
2023-03-01Product A400300           1,334004001,00  
2023-04-01Product A300500           0,608007001,14  
2023-05-01Product A200300           0,67100010001,00  
2023-06-01Product A   90011000,82 200
2023-07-01Product A     0,82 100
2023-08-01Product A     0,82 150
2023-09-01Product A     0,82 300
2023-10-01Product A     0,82 400
2023-11-01Product A     0,82 200
2023-12-01Product A     0,82 100
2023-01-01Product B200400           0,50000,00  
2023-02-01Product B200300           0,672004000,50  
2023-03-01Product B300500           0,604007000,57  
2023-04-01Product B100100           1,0070012000,58  
2023-05-01Product B300400           0,756009000,67  
2023-06-01Product B   70010000,70 200
2023-07-01Product B     0,70 300
2023-08-01Product B     0,70 150
2023-09-01Product B     0,70 300
2023-10-01Product B     0,70 400
2023-11-01Product B     0,70 200
2023-12-01Product B     0,70 100
1 REPLY 1
Ashish_Mathur
Super User
Super User

Hi,

Share the download link of the MS Excel file with your formulas written there so that the logic can be understood.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.