Forum Discussion

blazko's avatar
blazko
Icon for Helper III rankHelper III
8 years ago
Solved

MIN from four different tables

Hi I need a DAX formula to calculate min value (time in this ex) from four different columns that are in different tables.

The problem is when the MIN measure returns blank, so simple min(min ();min()) is not working. Please help!

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi blazko,

     

    Based on my test, the formula should work in your scenario. :smileyhappy:

    Measure =
MAXX (
    UNION (
        SELECTCOLUMNS ( Table1, "Date", Table1[Date1] ),
        SELECTCOLUMNS ( Table2, "Date", Table2[Date2] ),
        SELECTCOLUMNS ( Table3, "Date", Table3[Date3] ),
        SELECTCOLUMNS ( Table4, "Date", Table4[Date4] )
    ),
    [Date]
)

    Remark: just replace the bold with your real table name and column name.

     

    Regards

2 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi blazko,

     

    Based on my test, the formula should work in your scenario. :smileyhappy:

    Measure =
MAXX (
    UNION (
        SELECTCOLUMNS ( Table1, "Date", Table1[Date1] ),
        SELECTCOLUMNS ( Table2, "Date", Table2[Date2] ),
        SELECTCOLUMNS ( Table3, "Date", Table3[Date3] ),
        SELECTCOLUMNS ( Table4, "Date", Table4[Date4] )
    ),
    [Date]
)

    Remark: just replace the bold with your real table name and column name.

     

    Regards