Forum Discussion
elcamino
1 year agoFrequent Visitor
Projected Monthly Sales
Hello everyone, I need to know the projected monthly sales based on the sales of the last 2 years. However, when i use this measure: Projected Monthly Sales = VAR CurrentDate = MAX(DIM_DATE...
- Anonymous1 year ago
Hi elcamino ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Please don't forget to give a "Kudos " – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
OktayPamuk80
Responsive Resident
1 year agoHi,
you mean something like forcasting? If you use a linechart, you can have forecasting. See "Apply Forecasting" section of this link:
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane
Regards,
Oktay