Forum Discussion

lgs1983's avatar
lgs1983
Helper I
6 years ago
Solved

Calculated Table with Filter, showing specific columns

Hi,

 

I'm trying to create a calculated table where all those that have failed data validation end up.

 

The data validation is done in the table so I need to filter on the column in there when it equals 1. My only issue now is only bringing back certain columns into that calculated table as only a few are required.

Table = FILTER(AllTagExtracts, AllTagExtracts[ExtractDUNS Equals ERDDUNS Ind]=1)

As always, any help is appreciated.

Need Help
  • AnkitBI's avatar
    AnkitBI
    6 years ago

    Use SelectColumn like

     

    Table 2 = SELECTCOLUMNS(filter(Data,Data[Salary1] > 10),"Department",Data[Department],"Salary",Data[Salary1])

    Thanks
    Ankit Jain

    Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

2 Replies

  • AnkitBI's avatar
    AnkitBI
    Solution Sage
    6 years ago

    Use SelectColumn like

     

    Table 2 = SELECTCOLUMNS(filter(Data,Data[Salary1] > 10),"Department",Data[Department],"Salary",Data[Salary1])

    Thanks
    Ankit Jain

    Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

    • lgs1983's avatar
      lgs1983
      Helper I
      6 years ago

      That's how SELECTCOLUMNS works. Was one of the functions I was looking at but didn't know was a custom name you had to provide for the column header. Thanks very much AnkitBI