SelectedColumns - error

[PBIfanatic]

Hi,

I am using the SELECTEDCOLUMNS DAX function to create a table

Table = SELECTCOLUMNS(DimDate, "Test",DimDate[FullDateAlternateKey])

This gives me an error - A table of multiple values was supplied where a single value was expected. I chekc the documentation for this and I believe

I have all the correct details?

thanks

[amitchandak]

Seems fine. Is this some a formula -DimDate[FullDateAlternateKey] ?

[PBIfanatic]

Hi @amitchandak ,

No its a column from the DimDate table. 

[amitchandak]

@PBIfanatic 

Can you share a pbix after removing sensitive information?

I had one doubt you rae creating a measure, not a table, check that

[PBIfanatic]

Hi @amitchandak , I am trying to creating a table not a measure.

[v-xuding-msft]

Hi @PBIfanatic ,

Could you tell me if your problem has been solved? If yes,  welcome to share your own solution. More people will benefit from the thread. If not, please share some sample data and expected results. Then we will understand clearly.

Best Regards,

Xue Ding

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

[v-xuding-msft]

Hi @PBIfanatic ,

Can you please share some sample data and a few screenshots? Then we will understand clearly about your situation.