Forum Discussion
max
Hello, I m trying to set show latest production stage process from "tjob" table, "secondnumber" column to main order table "MrpTableAll".
Relation is made by PO. Tjob (many) > mrptableall (one).
Any thoughts? If you need more inf., wirte it down.
- Anonymous3 years ago
Ok, i managed to solve it using dax, max and ALLEXCEPT but I m having first empty row with the highest number from all and total also with highest number
Cant see dont sum option anywhere
5 Replies
- tamerj1Community Champion
Hi Anonymous
is it a calculated column that you're trying to calculate?
which column contains the production stage? In which table?
which column shows the stage order? In which table? Is it the same production stage column ?
which column
- AnonymousNot applicable
"tjob" table, "secondnumber" column is production stage, defined by a number. Doesnt matter is its calculated column or dax expression as long it works. Production stage has to be filtered by production order. "Tjob" table, "primerNumber" column
There are multiple entries for the same production stage and production orders, devided into smaller quantity processes
it can be calcuted column or dax expression
- AnonymousNot applicable
Ok, i managed to solve it using dax, max and ALLEXCEPT but I m having first empty row with the highest number from all and total also with highest number
Cant see dont sum option anywhere
- tamerj1Community Champion
what is there in the rows of this matrix?
- AnonymousNot applicable
2 columns with numbers, 1 columnn with text
Adding +1 value into ProductNumber column slicer from "MRPTableAll" eliminates the empty row but the the origin is still unknown.