Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Dear Community,
I tried to create a formula which get the minimum values from 2 columns and put it to another column (Mid case):
=MIN(B2;C2)+D2
B C D
Product | Open quantity | Stock | Secured | Mid case |
A | 1 776 | 2 675 | 1 104 | 2 880 |
B | 654 | 3 016 | 1 405 | 2 059 |
C | 1 842 | 4 365 | 2 045 | 3 887 |
Does anyone has a solution for this?
Thank you,
Anett
Solved! Go to Solution.
Just for debugging, create one column which just pulls the min of the 2 values,
Mid case = MIN('Rendelési adatok'[Open qty],RELATED(pivot[Sum of stock])),
and then create another column which is just
Secured stock = [Secured]
That should help to pinpoint where the problem lies, either in the MIN or in the measure.
How are the 2 tables related ?
Dear @johnt75
The relationship looks like this:
The first table contains the column which should be placed in the MIN function, the other one is in the second table, in the second column. So those columns which should be placed in the MIN function are contains whole number values. The common point between the 2 tables is the hybrid names.
The code you posted using RELATED should work if you are adding the column to the 'Rendelési adatok' table. Use the data view to sort that table first by Open Qty and then by Secured, see if you have negative values in there.
Dear @johnt75
And there is any other solution which calculating MIN between 2 value from 2 different table using their relationship?
Or I must add somehow the 2 value in 1 column and it is not enough that they have relationship and in the visual they are in the same table?
Is [Secured] a measure or a column? If it is a column, which table is it in? If it is a measure, what is the definition ?
Hi @johnt75
I have 2 table, 1 contains the open qty and another 1 is the stock. I have to "compare" this 2 value and get the min of them, then add to it my secured value, which is a measure (sum of 2 other value).
Can you post the DAX that is giving the error
Hi @johnt75
Sure, this is what I used:
You added that as a column on the 'Rendelési adatok' table, right? Not as a measure? Because that looks to me like it should work
HI @johnt75
I checked it again and it worked well, sorry.
But if I would like to add to it the Secured values (Secured is a measure in another table), the values became high negative numbers.
OK, something from 'Rendelési adatok' is probably filtering the tables involved in the [Secured] measure, either directly. Because you have a row context on 'Rendelési adatok' then every column in the expanded table is being added to the filter context when you compute the measure. You probably want to restrict the columns using ALLEXCEPT.
Hi @johnt75
Thanks for your continuous help. I used finally an extra step, and not directly added the Secured values to the MIN ones, and it worked well 🙂
Just for debugging, create one column which just pulls the min of the 2 values,
Mid case = MIN('Rendelési adatok'[Open qty],RELATED(pivot[Sum of stock])),
and then create another column which is just
Secured stock = [Secured]
That should help to pinpoint where the problem lies, either in the MIN or in the measure.
Dear @johnt75
Thank you for the tip, but it is not working. I have to use 2 different source, so I tried this one
You can create a calculated column like
Mid case =
MIN ( 'Table'[Open quantity], 'Table'[Stock Secured] )
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
141 | |
121 | |
112 | |
59 | |
58 |