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...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

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

 

PBIfanatic's avatar
PBIfanatic
Helper V
6 years ago

Hi amitchandak ,

 

No its a column from the DimDate table. 

 

  • 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

     

    • PBIfanatic's avatar
      PBIfanatic
      Helper V
      6 years ago

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

       

      • v-xuding-msft's avatar
        v-xuding-msft
        Community Support
        6 years ago

        Hi PBIfanatic ,

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