[DAX] MIN function rejects single column table as argument

[tomdiben]

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

[PhilipTreacy]

Hi @tomdiben 

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

[PhilipTreacy · Accepted solution]

Hi @tomdiben 

Use MINX like this example

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

Regards

Phil

[tomdiben]

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