Calculated Table with Filter, showing specific columns

[lgs1983]

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.

[AnkitBI · Accepted solution]

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]

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