Forum Discussion
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!
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]
3 Replies
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]
Thank you Greg_Deckler , positive result!
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
