Cannot return multiple values

[3cdoug]

Expi_Names =

VAR CurrentDate = TODAY()

VAR OneYearAgo = EDATE(CurrentDate, -12)

 RETURN

    SELECTCOLUMNS(

        FILTER(ADDCOLUMNS(Roster,"Expired", DATEVALUE(Roster[Last Date])), [Expired Date] < OneYearAgo), "Last Name", Roster[Last Name], "First Name", Roster[First Name])

This is the syntax within DAX that I am using but I keep getting the error of multiple rows cannot be converted into a scalar value, any help on how to fix this?

[amitchandak · Accepted solution]

@3cdoug , SELECTCOLUMNS returns a table, so in case you are using it measure or column it will give an error for measure or column use sumx, maxx, minx etc to ensure one value per row

[Ritaf1983 · Accepted solution]

Hi @3cdoug 

Are you trying to create the measure?
Because this expression's result is table...and measure should be a scalar value...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @3cdoug ,

I guess what you mean is you want to print multiple lines of results. You can try the IF function. It's 1 if it's in your rule or 0 if it's not. Finally, you can filter the result you want by setting this measure to 1 through Filter.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983 · Accepted solution]

Hi @3cdoug 

Are you trying to create the measure?
Because this expression's result is table...and measure should be a scalar value...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@3cdoug , SELECTCOLUMNS returns a table, so in case you are using it measure or column it will give an error for measure or column use sumx, maxx, minx etc to ensure one value per row