Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

[DAX] MIN function rejects single column table as argument

Hi all!

I was wondering if [Single-Column Table] = [Column] for Power BI?

I'm trying to use the MIN function on a table I create dynamically with TOPN and it gives me the "The MIN function only accepts a column reference as an argument." altough I made sure I'm sending a single column table as an argument.

This is the data it's built upon:

 

Thanks!!
Thomas

Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

     

    Use MINX like this example

     

    MINX(SELECTCOLUMNS(TOPN(2,'Submission Date', 'Submission Date'[Submission Date],DESC),"Index",[Index]), [Index])

     

     

    Regards

     

    Phil

3 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous 

     

    Use MINX like this example

     

    MINX(SELECTCOLUMNS(TOPN(2,'Submission Date', 'Submission Date'[Submission Date],DESC),"Index",[Index]), [Index])

     

     

    Regards

     

    Phil

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      That works, thanks Phil!

      Are you able to tell why the MIN function was rejecting my single column table? And why it works better with MINX?

      Thanks!

      Thomas

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous 

     

    SELECTCOLUMNS returns a table but MIN requires a column (or a scalar value) as an argument.  MINX takes a table as an argument then works through each row.

     

    So even though you are creating a table, consisting of just one column, using SELECTCOLUMNS, it's still creating a table, and MIN doesn't like that.

     

    MIN – DAX Guide

    MINX – DAX Guide

    SELECTCOLUMNS – DAX Guide

     

    Regards

     

    Phil