cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

How to get the product of a whole row of numbers

Hi,
How do you get the same formula "product" from excel on power bi?
I have this measure that calculates the ratio of two dates and then I took a few different averages from this ratio measure like AVG 3, AVG 6.

My question is: How can I get the product of the average row?

Thanks in advance for the help.

Michelle

3 REPLIES 3
Community Support

Hi @mluanacruz ,

In DAX, there is the same PRODUCT function as in Excel. But it returns the product of the numbers in a column not a row.

PRODUCT function (DAX) - DAX | Microsoft Learn

You may first unpivot the columns to make rows convert to one column.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Memorable Member

Hi @mluanacruz,

You can use:

``Product = IF('Table'[Period]="AVG 3", 'Table'[1-Ult],0) * IF('Table'[Period]="AVG 6", 'Table'[1-Ult],0)``

Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI

Helper I

Hi @Shaurya ,
Thanks for the help.
I am trying to understand your measure. Did you have time to take a look at my Power BI one drive?

`Product = IF('Table'[Period]="AVG 3", 'Table'[1-Ult],0) * IF('Table'[Period]="AVG 6", 'Table'[1-Ult],0)`

1) Are you multiplying the AVG 3 * AVG 6? Because my end goal is to get the product of the whole Average 3 row, like the picture, I attached below:

2) Table[period] and Table[1-Ult] - Will the period be the date I am using? but what is Table[1-Ult]?

I am trying to understand a little bit better what you did.

Thanks again for the help.

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors