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 i...
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.

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