Using ProductX with a measure rather than a column

Question

Hi all&nbsp;I've got some sales data where I want to project forward total sales amount based on known year on year % change. The data for the Year on Year % change value is a measure that is calculated based of the results of another table.&nbsp;The data looks like this:&nbsp;YearCountryNameKnown SalesYoYChange2000Germany$7,364,111&nbsp;2001Germany$9,398,5818.30%2002Germany$12,143,72310.00%2003Germany$15,186,21712.30%2004Germany$18,090,81414.00%2005Germany$20,601,21916.00%2006Germany$23,360,53515.80%2007Germany$25,346,27913.10%2008Germany$26,691,6966.40%2009Germany$29,295,8412.50%2010Germany$31,046,735-0.30%2011Germany$31,308,378-2.80%2012Germany$32,585,961-3.90%2013Germany$34,091,290-3.50%2014Germany$41,924,198-2.80%2015Germany$43,367,394-1.70%2016Germany$43,886,104-0.10%2017Germany$44,127,5090.70%2018Germany$44,935,1691.40%2019Germany$46,993,6140.90%2020Germany&nbsp;-0.60%2021Germany&nbsp;2.10%2022Germany&nbsp;1.30%2023Germany&nbsp;1.50%2024Germany&nbsp;1.80%2025Germany&nbsp;2.20%2026Germany&nbsp;2.40%2027Germany&nbsp;2.50%2028Germany&nbsp;2.40%2029Germany&nbsp;2.30%2030Germany&nbsp;2.30%&nbsp;The data I want outputted is an extra column which basically takes the last known sales amount and multiples out the future year on year growth rates. Expected output would be something likefuture sales in the table below.&nbsp;YearCountryNameKnown SalesYoYChangeFuture Sales2000Germany$7,364,111&nbsp;&nbsp;2001Germany$9,398,5818.30%&nbsp;2002Germany$12,143,72310.00%&nbsp;2003Germany$15,186,21712.30%&nbsp;2004Germany$18,090,81414.00%&nbsp;2005Germany$20,601,21916.00%&nbsp;2006Germany$23,360,53515.80%&nbsp;2007Germany$25,346,27913.10%&nbsp;2008Germany$26,691,6966.40%&nbsp;2009Germany$29,295,8412.50%&nbsp;2010Germany$31,046,735-0.30%&nbsp;2011Germany$31,308,378-2.80%&nbsp;2012Germany$32,585,961-3.90%&nbsp;2013Germany$34,091,290-3.50%&nbsp;2014Germany$41,924,198-2.80%&nbsp;2015Germany$43,367,394-1.70%&nbsp;2016Germany$43,886,104-0.10%&nbsp;2017Germany$44,127,5090.70%&nbsp;2018Germany$44,935,1691.40%&nbsp;2019Germany$46,993,6140.90%&nbsp;2020Germany&nbsp;-0.60%$ 46,711,6522021Germany&nbsp;2.10%$ 47,692,5972022Germany&nbsp;1.30%$ 48,312,6012023Germany&nbsp;1.50%$ 49,037,2902024Germany&nbsp;1.80%$ 49,919,9612025Germany&nbsp;2.20%$ 51,018,2002026Germany&nbsp;2.40%$ 52,242,6372027Germany&nbsp;2.50%$ 53,548,7032028Germany&nbsp;2.40%$ 54,833,8722029Germany&nbsp;2.30%$ 56,095,0512030Germany&nbsp;2.30%$ 57,385,237&nbsp;I'm nearly certain the approach used in this video by Curbal is the way to do it - that is using PRODUCTX iterator function to calculate out. However, ProductX only takes acolumn as a its second argument...but I want to pass a measure.&nbsp;The PRODUCTX function takes as its first argument a table, or an expression that returns a table. The second argument is a column that contains the numbers for which you want to compute the product, or an expression that evaluates to a column.&nbsp;I cannot find a way to do the same thing using a measure - after days of research. Does anyone know of a workaround or how I could potentially parse my measure as a column so the ProductX function can evaulate future sales?&nbsp;Any help would be highly appreciated!&nbsp;CheersDM

amitchandak · Answer

Anonymous , check if measure like this can help
&nbsp;
measure = var _year = maxx(allselected(Table),Table[Year])return maxx(filter(Table, Table[year] = _year),[YoYChange])* PRODUCTX(filter(allselected(Table), Table[Year] &lt;=max(Table]) &amp; &amp;Table[year] &gt; _year ), 1+ YoYChange)

anonymous · Answer

Thanks for the reply amitchandak. I'll have to give that a whirl in the morning...was wondering what that measure is actually doing though?&nbsp;

Forum Discussion

Using ProductX with a measure rather than a column

2 Replies

Related content

ProductX not working with measure (alternative)

ProductX Iterative Calculation

Measure - can't add back 1 to productx formula

DAX Measure

Measure

Year	CountryName	Known Sales	YoYChange
2000	Germany	$7,364,111
2001	Germany	$9,398,581	8.30%
2002	Germany	$12,143,723	10.00%
2003	Germany	$15,186,217	12.30%
2004	Germany	$18,090,814	14.00%
2005	Germany	$20,601,219	16.00%
2006	Germany	$23,360,535	15.80%
2007	Germany	$25,346,279	13.10%
2008	Germany	$26,691,696	6.40%
2009	Germany	$29,295,841	2.50%
2010	Germany	$31,046,735	-0.30%
2011	Germany	$31,308,378	-2.80%
2012	Germany	$32,585,961	-3.90%
2013	Germany	$34,091,290	-3.50%
2014	Germany	$41,924,198	-2.80%
2015	Germany	$43,367,394	-1.70%
2016	Germany	$43,886,104	-0.10%
2017	Germany	$44,127,509	0.70%
2018	Germany	$44,935,169	1.40%
2019	Germany	$46,993,614	0.90%
2020	Germany		-0.60%
2021	Germany		2.10%
2022	Germany		1.30%
2023	Germany		1.50%
2024	Germany		1.80%
2025	Germany		2.20%
2026	Germany		2.40%
2027	Germany		2.50%
2028	Germany		2.40%
2029	Germany		2.30%
2030	Germany		2.30%