How to find data in table.

[gopichilla]

I am facing a problem getting data into the table. The condition is (In a table having a Department column and other columns, in department column contains a HR, Financial, Account, etc.  But I want only HR department data)

Thanks, 

Gopi.

[v-ljerr-msft · Accepted solution]

Hi @gopichilla,

Could you post some sample data of your Department column with your expected result? So that we can help to write the query for you.

Regards

[v-ljerr-msft · Accepted solution]

Hi @gopichilla,

In this scenario, you can use ADDCOLUMNS or SELECTCOLUMNS function(DAX) to create a new calculate table with the Department data you want. The formula below is for your reference.

NewTable =
ADDCOLUMNS (
    FILTER ( Table1, Table1[Department] = "Web Development" ),
    "HR Department", Table1[Department]
)

Note: Replace "Table1" with your real table name in the formula above.

Regards

[v-ljerr-msft · Accepted solution]

Hi @gopichilla,

A little confused! Could you post your expected result against the sample data above?

Regards

[Greg_Deckler]

Well, you can filter that in your query, or create a slicer in your report and just slice out HR.

[gopichilla]

Thank u for your answer. 

It possible but we want any query by creating the new column.

[v-ljerr-msft · Accepted solution]

Hi @gopichilla,

Could you post some sample data of your Department column with your expected result? So that we can help to write the query for you.

Regards

[gopichilla]

In this above image, i want only web Development.Place solve the issue.

Thanks,

Gopi. 

[v-ljerr-msft · Accepted solution]

Hi @gopichilla,

In this scenario, you can use ADDCOLUMNS or SELECTCOLUMNS function(DAX) to create a new calculate table with the Department data you want. The formula below is for your reference.

NewTable =
ADDCOLUMNS (
    FILTER ( Table1, Table1[Department] = "Web Development" ),
    "HR Department", Table1[Department]
)

Note: Replace "Table1" with your real table name in the formula above.

Regards

[gopichilla]

Thank you

[gopichilla]

In this scenario, you can use ADDCOLUMNS or SELECTCOLUMNS function(DAX) to create a new calculate table with the Department data you want. The formula below is for your reference.

NewTable =
ADDCOLUMNS (
    FILTER ( Table1, Table1[Department] = "Web Development" ),
    "HR Department", Table1[Department]
)

Note: Replace "Table1" with your real table name in the formula above.

In this above function and query created a new table, But I want in the same table create a new column based on the above condition.

Thanks,

Gopi

[v-ljerr-msft · Accepted solution]

Hi @gopichilla,

A little confused! Could you post your expected result against the sample data above?

Regards

[gopichilla · Accepted solution]

Thank u for helping I got a solution to my problem.