Forum Discussion

remi's avatar
remi
Icon for Advocate II rankAdvocate II
8 years ago
Solved

copy a table and filter it

Hello all,   Is there a function that can help to copy a table and then filter based on a specific value from one column without doing it from the Edit Query side?   Thank you!
Tips and Tricks
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Yes, you go to the modeling tab and choose "New Table" and you can plug in syntax like:

     

    Table 1 = FILTER('Table',[Column] = "Value")

    You will end up with a new table of only the rows in the source table 'Table' that have "Value" in [Column]

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Yes, you go to the modeling tab and choose "New Table" and you can plug in syntax like:

 

Table 1 = FILTER('Table',[Column] = "Value")

You will end up with a new table of only the rows in the source table 'Table' that have "Value" in [Column]

 

 

  • remi's avatar
    remi
    Icon for Advocate II rankAdvocate II
    8 years ago

    Thank you Greg_Deckler , positive result!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi i am looking for some help, if i wanted the value to be a range (last 31 days) from a date column do you knwo how i can do this in power BI DAX?

    I can get it to work to pull oly todays date, but want it to dynamically create a table with the last 31 days from a larger table.

    Table = FILTER('Safety Score table', 'Safety Score table'[Date] = TODAY())

     

    Thanks in advance