Forum Discussion

WorkHard's avatar
WorkHard
Helper V
6 years ago
Solved

Create table with specific columns from another table, rename the columns and add a filter criteria

Is it possible to do these three things in the process of creating a table?  I'm new to DAX and can't decide if I can attack these 3 issues in a single formula.   Scenario simplified: Let's say I...
Need Help
  • FrankAT's avatar
    FrankAT
    6 years ago

    Hi,
    give this a try:

     

    SELECTCOLUMNS(
    FILTER(Projects, Projects[Start Date] >= DATE(2020,1,1)),
    "Project",Projects[Project Name],
    "Start",Projects[Start Date]
    )

     

    Regards FrankAT

FrankAT's avatar
FrankAT
Community Champion
6 years ago

Hi,
give this a try:

 

SELECTCOLUMNS(
FILTER(Projects, Projects[Start Date] >= DATE(2020,1,1)),
"Project",Projects[Project Name],
"Start",Projects[Start Date]
)

 

Regards FrankAT