Create Table with specific detailled columns

DAX DAX Calculations
1

Hey guys
I’ve created a table like this:

NOT Inv & No Client =
FILTER (
‘Tab TimeSheet’,
‘Tab TimeSheet’[Invoiced] = “No”
&& ‘Tab TimeSheet’[ClientID] <> BLANK ()
)
Anyway of instead of all the columns that i get, just choose TS ID, Date and Project ID columns?
Thank you all
Pedro

2

Hi @pedroccamara,

DAX function names are pretty descriptive…

SELECTCOLUMNS returns a table with selected columns from the table and new columns specified by the DAX expressions. Read more here:

1 Like
3

I just love the simplicity of the solution…

NOT Inv & W Client =
FILTER (
SELECTCOLUMNS (
‘Tab TimeSheet’,
“Employee”, ‘Tab TimeSheet’[Employee ™],
“TS ID”, ‘Tab TimeSheet’[TS ID],
“Client ID”, ‘Tab TimeSheet’[ClientID],
“Date”, ‘Tab TimeSheet’[Date],
“Project ID”, ‘Tab TimeSheet’[ProjectID]
),
[Invoice No & W Client]
)

Thank you so much @Melissa