Alternative formula to Productx to use in measure in Excel 2013

[anto0351]

Hey Guys,

I am currently working on a project where I need the measures of my power pivot to be able to work in both excel 2016 and 2013.

I have used the formula "Productx" and it is working in my excel 2016, but when I test it in excel 2013, it says it is not convertible.

I am therefore looking for an alternative that is useable in both excel 2013 and 2016 and hoping that one of you guys can help me with a new measure to use instead of my current one labeled "Current measure" as can be found both in the sample workbook attached through Google Drive and here in the bottom. The measure should of course yield the same results as the current one does - these can be found in the table in the workbook.

Link to sample workbook: https://drive.google.com/file/d/1lrVBoulzN_kmE5TfBHLpB-PmNmnbx-E0/view?usp=sharing

The current measure: "=CALCULATE(PRODUCTX(Table1, 1 + Table1[Value]),FILTER(ALLSELECTED(Table1[Date]),Table1[Date] <= MAX(Table1[Date] )))*100"

I look forward to hearing your solutions.

Best regards,

Anton

[AlB · Accepted solution]

Hi @anto0351 

Measure =
CALCULATE (
    POWER ( 10, SUMX ( Table1, LOG10 ( 1 + Table1[Value] ) ) ),
    FILTER ( ALLSELECTED ( Table1[Date] ), Table1[Date] <= MAX ( Table1[Date] ) )
) * 100

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers