Create new table containing subset of data from existing table, but meeting a date condition

[Anonymous]

In my dataset, I have a table called DEALS, which contains 50+ columns. Three of the columns are called Deal Number, Rate Date and Rate Value.

I would like to create a new table which pulls Deal Number, Rate Date and Rate Value from the DEALS table, but only for rows where the Rate Date column contains Jan 31, 2020.

I tried this using the FILTER function - it created the new table with the date condition enforced, but it pulled all columns from DEALS, and I only need three.

Any advice on what function I could use? Thanks in advance!

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[camargos88]

Hi @Anonymous ,

You can try it using filter and selectcolumns.

https://docs.microsoft.com/en-us/dax/selectcolumns-function-dax

Ricardo