Forum Discussion
Create a table with min value as a column
Hi, I am still new at DAX and stumbling on this issue: I need to create a table that shows the minimum value of a row per ID. The row value itself comes from a SQL. This is what I wrote. In...
Hi Berl21
Please try
Table Test Summarize =
SUMMARIZE (
'Partition_Rank_SQL',
'Partition_Rank_SQL'[DimOpportunityId],
'Partition_Rank_SQL'[ID_Row],
"MININDEX",
CALCULATE (
MIN ( 'Partition_Rank_SQL'[ID_Row] ),
ALL ( 'Partition_Rank_SQL'[ID_Row] )
)
)
