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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

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.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors