Forum Discussion
Solved
Calculate Minimum Across Multiple Tables by Row
Hello, so I have 4 tables that are related by a primary reference number. In each of the 3 tables, there is a column X, Y, and Z. What I would like to do is create a new table that lists the primary ...
Hi GSynchro ,
Try this 3 measures:
mX = Calculate(Minx(Union('Table 1','Table 2','Table 3'), [X]))mY = Calculate(Minx(Union('Table 1','Table 2','Table 3'), [y]))mZ = Calculate(Minx(Union('Table 1','Table 2','Table 3'), [Z]))My output based on your sample data
Let me know fi this works
Thanks,
Tejaswi
Hi GSynchro ,
Try this 3 measures:
mX = Calculate(Minx(Union('Table 1','Table 2','Table 3'), [X]))mY = Calculate(Minx(Union('Table 1','Table 2','Table 3'), [y]))mZ = Calculate(Minx(Union('Table 1','Table 2','Table 3'), [Z]))My output based on your sample data
Let me know fi this works
Thanks,
Tejaswi
Yes! This worked perfectly!!! Thank you so much