Forum Discussion

gopichilla's avatar
gopichilla
Icon for Resolver III rankResolver III
9 years ago
Solved

How to find data in table.

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 ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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.:smileyhappy:

     

    Regards

  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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.:smileyhappy:

    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's avatar
    v-ljerr-msft
    9 years ago

    Hi gopichilla,

     

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

     

    Regards

  • gopichilla's avatar
    gopichilla
    9 years ago

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

gopichilla's avatar
gopichilla
Icon for Resolver III rankResolver III
9 years ago

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.Smiley Happy

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's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi gopichilla,

 

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

 

Regards

  • gopichilla's avatar
    gopichilla
    Icon for Resolver III rankResolver III
    9 years ago

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