copy a table and filter it

[remi]

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!

[Greg_Deckler · Accepted solution]

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]

[Anonymous]

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

[remi]

Thank you @Greg_Deckler , positive result!