Forum Discussion
[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
Hi tomdiben
Use MINX like this example
MINX(SELECTCOLUMNS(TOPN(2,'Submission Date', 'Submission Date'[Submission Date],DESC),"Index",[Index]), [Index])Regards
Phil
3 Replies
Hi tomdiben
Use MINX like this example
MINX(SELECTCOLUMNS(TOPN(2,'Submission Date', 'Submission Date'[Submission Date],DESC),"Index",[Index]), [Index])Regards
Phil
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
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.
Regards
Phil
