Forum Discussion

bcampbell's avatar
bcampbell
Helper I
7 years ago
Solved

New Table with specific values from another table column

I have a Table that contains 2 columns that i want to create a new table from 

 

1 of those columns is date / time of  and the other column contains a 4 letter value

 

I would like to make a new table with specific 4 letter value and aslo the column that contains date/time

 

How could i do this from a Dax expression ?

 

Thanks

Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi bcampbell

     

    You can simply create a new table with this code:

     

    NewTable = FILTER(YourCurrentTable; YourCurrenTable[Value]="ABCD")

     

    where "ABCD" is the specific 4-letter value you want to keep.  

1 Reply

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi bcampbell

     

    You can simply create a new table with this code:

     

    NewTable = FILTER(YourCurrentTable; YourCurrenTable[Value]="ABCD")

     

    where "ABCD" is the specific 4-letter value you want to keep.