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

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

Reply
Anonymous
Not applicable

Would love some help on Trending out Sales Year to Go

Hello There,

I have 2 Fact Tables



1 is Fact POS Table- Using "POS Value USD" Column

Ukfan123_0-1661281648537.png

 

 

Ukfan123_1-1661281648556.png

 

 


2 is Fact Shipments Table- Using "Gross Ships USD" Column

Ukfan123_2-1661281648579.png

 

 

Ukfan123_3-1661281648648.png

Ukfan123_4-1661281788771.png

 

My Shipments table has actuals (year to date actualized shipped $), and it also includes a forecast for remaining year periods

I would like to be able to trend out my "POS Value USD" (See orange line in chart above) using Year to Date periods, and Last 3 Periods, to get a forecast for the "POS Value USD" for the reamining periods of the year. 

What would be the best way to achieve this? Thanks so much!

1 REPLY 1
HoangHugo
Solution Specialist
Solution Specialist

Hi

I understand you forcasting remaining year by average sales of last 3 periods

if so, please try this measure for Orange line

 

Orange_line =
var a = CALCULATE (YTD sales, DATEADD(date,-1,year)

var b = CALCULATE (YTD sales, DATEADD(date,-2,year)

var c = CALCULATE (YTD sales, DATEADD(date,-3,year)
return if (Date <= TODAY(), YTD sales, (a+b+c)/3)

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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