Forum Discussion

GSynchro's avatar
GSynchro
Regular Visitor
7 years ago
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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

I suggest you try this approach:

  1. Append data from all 3 Tables into a 4th Table
  2. Select the first column of the 4th Table, right click and select "Unpivot other columns"
  3. To your visual, drag the first column to the row labels, second to the column labels and write this measure

=MIN(Data[Value])

Hope this helps.