DAX Fridays 158: PRODUCTX - Growth rate calculations

[@schauenburgcaio]

4 years since this video was uploaded and help me a lot... Thank you!!!!

[@aliharvey6408]

I just started using PBI after switching from a different software. Im so glad i found your channel!!! :)

[@CurbalEN]

Welcome Ali :)

[@nicodevries596]

Hi Ruth, is it also possible to wrap this up in a custom column instead of a measure?

[@张泽文-q5r]

Thanks a lot! I googled 2 hours to find this trick and finally get it from your video. Give you a big thumb up! Manually!

[@CurbalEN]

Received, thanks!!

What a very helpful video. Thanks a lot. But could we make the output depend on the starting point? Like, when the table starts from Year 2 (not from Year 1), Return P1 would be 105%, then 105% * 108% for next Year?

[@eslileal]

Very good! One question: would you have an example of how to update a database by monthly inflation indices?

[@macshock632]

Cool! But what if I need to keep a certain filter. I do not want to remove all.?

[@josesalgado6526]

Very good! How to manage it if the accumulated product refers to one year only? That means that every January of a new year you've got to start cumulating the product from zero.

[@DarraghMurray]

This approach is really exactly what I need Curbal...but the main issue is that I need to calculate with ProductX base don a measure rather than a column. I cannot find any solution to this - nor a way I can force my measure to convert to a column so I can use with ProductX. Any solution for this dilemma Curbal?

[@filipwinski4219]

Hello Ruth, I struggled with this problem some time ago, and I really followed exactly the same steps as you've just presented. I was confused each time until I found this solution (the only difference was that I used dates instead of years no). Thank you for a great video!!!

[@CurbalEN]

Happy Friday Filip! /Ruth

[@aldanacampos4968]

If i want to make it but with values that are previously accumulated. How can i do it?

[@miltinhocamo3754]

Hola Ruth... excelente ejemplo. Noté que el total no varió.... ¿tienes una aclaración para ello?. Cordial saludo.

[@CurbalEN]

Totals are calculated differently than Excel, check this out: kzbin.info/www/bejne/q5ergIKCmc6SoM0&vl=en /Ruth

[@takahama2655]

Thank you It was very helpful. From Japan

[@CurbalEN]

Glad to hear and arigato ;) /Ruth

[@vslaser]

Hi, I am trying to run a Productx function a table with if condition. However, I am getting the wrong answer. Can you please look at the formula and tell me if something is wrong with it? CALCULATE(PRODUCTX( 'Test Freq + Config', CALCULATE(calculate( if((VALUES('Test Freq + Config'[Configuration]) == "1oo1"), element_av,if((values('Test Freq + Config'[Configuration]) == "2oo2"), power(element_av,2), if((values('Test Freq + Config'[Configuration]) == "N/A"), 1,if((values('Test Freq + Config'[Configuration]) == "1oo2"),(1 - power((1-element_av),2)),if((values('Test Freq + Config'[Configuration]) == "3oo4"), (4*power(element_av,3) - 3*power(element_av,4)),1))))),WOs[REPORTDATE+Time]>=MinDate, WOs[REPORTDATE+Time]

[@udusegbe]

Cool & timely. Exactly what I need calculating financial returns in my reports👏😀

[@CurbalEN]

👏👏👏just on time!! Happy Friday :) /Ruth

[@DIGITAL_COOKING]

I think we call this calculation geometric mean, ko interesting video Just one question can we use "earlier" function

[@CurbalEN]

Give it a go and you’ll see , the file is available for download in the download center. The geomean calculation I leave it for next week :) /Ruth

[@김차수-k2u]

fantastic function ! Thank you for your video, it would useful when using business in business situation!!!

[@CurbalEN]

Thanks and enjoy the rest of the Sunday:) /Ruth

[@rockfreedy]

Thank you!

[@rockfreedy]

Do you know why when i copy your formula, I am only getting the 115 (the total compounded growth) in each row?

[@rockfreedy]

Sorry i see what's happening....is there a way to do this at the table level instead of the visual level?

[@EricaDyson]

Great. Could we use REMOVEFILTERS as well? Ruth, I sent you an email .. did you get it?

[@CurbalEN]

Hi Erica, I haven’t seen one, let me check again and happy Friday! /Ruth

[@pabeader1941]

I think I just unlearned something. This example is very confusing. Why put a filter in and then not use it?

[@CurbalEN]

You are using it, just another form of filter ;) Happy Friday! /Ruth