topic Re: How to compute sales projection for the below question in DAX Commands and Tips

How to compute sales projection for the below question

Heena9980 — Tue, 11 Jan 2022 11:04:21 GMT

A business owner needs a Power BI report which shows projected sales for the next year. The sales field is in the "reports" table. A sale is represented by the "sales" field. The "reports" table contains only data for the current year.

Fill in the blank of the following DAX expression for a new column that will compute the sales projection as the current year's sales plus 12 percent growth:

Next Year Sale =  * 1.12

Re: How to compute sales projection for the below question

amitchandak — Tue, 11 Jan 2022 12:01:55 GMT

Heena9980 , We need to get this year sales first

Based on selected date in page

This year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))

This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))

Based on today

YTD Today=
var _year = year(today())
return
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'), year('Date'[Date]) = _year) )

You can mutiple these by 1.2

treat hem as previous year - next year is selected

Last year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))

Re: How to compute sales projection for the below question

Naveen132 — Thu, 20 Apr 2023 07:31:06 GMT

Hi Heena9980,

for a calculated column you can use

Projected Quantity =

items[quantity] * 1.12

Note: but you may also need to define the projected date in another column.