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
Hello There,
I have 2 Fact Tables
1 is Fact POS Table- Using "POS Value USD" Column
2 is Fact Shipments Table- Using "Gross Ships USD" Column
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!
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)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
95 | |
86 | |
78 | |
66 |
User | Count |
---|---|
150 | |
118 | |
111 | |
106 | |
95 |