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

Omega's avatar
Omega
Impactful Individual
6 years ago

Hi,

 

You can do the same using Power Query. Try applying the below steps: 

 

1- Click on Edit Query

2- Select the Query/Table you want to replicate

3- Right click on the query and select Reference

4- Manipulate the new query by changing the column names and filter the date