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 acc...
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

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