topic Re: HOW to simulate a DIVIDEX in DAX Commands and Tips

HOW to simulate a DIVIDEX

Anonymous — Wed, 05 Jun 2024 10:01:12 GMT

Is there any way to simulate a DIVIDEX (which it's not available) in DAX?

For Istance, if I want to simulate a division row by row from 'table1'[column1] and 'table1'[column2], it is possible to use the invers of PRODUCTX?

Thanks in advance
AG

Re: HOW to simulate a DIVIDEX

lbendlin — Wed, 05 Jun 2024 13:28:45 GMT

That's not the inverse of PRODUCTX. PRODUCTX multiplies across row, not across columns.

Please describe your business scenario, and maybe provide some sample data.

Re: HOW to simulate a DIVIDEX

Anonymous — Wed, 05 Jun 2024 13:36:43 GMT

I have to divide across rows (sales invoice line), the data in the column of the total amout and the data in quantity column.

Re: HOW to simulate a DIVIDEX

lbendlin — Wed, 05 Jun 2024 23:58:06 GMT

You didn't share sample data so this is only a guess

SUMX(table1,DIVIDE([column1],[column2])

Re: HOW to simulate a DIVIDEX

Anonymous — Mon, 10 Jun 2024 08:08:07 GMT

I thought the DIVIDE function divided not line by line (like it was a DIVIDEX which I know doesn't exist), and I didn't understand why you also used the SUMX.

What I need is to calculate an amount-quantity ratio for each invoice line such that I have a series of unit prices. At this point, for each data filter the customer inserts, it will use the unit value calculated above, relating to the previous period of the one selected, to calculate an average (I don't explain more because i think it's not relevant for the question I asked).

p.s. Sorry if I didn't insert example values, but on one hand they are customer's data, and on the other they are just two columns of numbers, so I thought you just didn't need it.

Re: HOW to simulate a DIVIDEX

lbendlin — Mon, 10 Jun 2024 12:15:11 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523