Forum Discussion

PBIfanatic's avatar
PBIfanatic
Helper V
6 years ago

SelectedColumns - error

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

 

Need Help

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

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

     

      • amitchandak's avatar
        amitchandak
        Super User
        6 years ago

        PBIfanatic 

        Can you share a pbix after removing sensitive information?

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