cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anto0351
Helper I
Helper I

Alternative formula to Productx to use in measure in Excel 2013

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

1 ACCEPTED SOLUTION
AlB
Super User III
Super User III

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 

 

SU18_powerbi_badge

View solution in original post

1 REPLY 1
AlB
Super User III
Super User III

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 

 

SU18_powerbi_badge

View solution in original post

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors