Forum Discussion

PeteyG's avatar
PeteyG
Helper I
2 years ago
Solved

Duplicating a Table based on an Activities Moving Date.

Hello-  I need to make a duplicate of the table below based on the Activity ID and Forecast Finish.  ACT-Con-016 is the end of 60% Design.  The issue is the Forecast dates can change with weekly dat...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi PeteyG 

     

    You can first duplicate the query, 

    In the new query, filter rows by [Activity ID] column and select Equals... and set it to equal to ACT-Con-016. This will give you the formula like below in the formula bar and remain only one row in the outcome. 

    = Table.SelectRows(#"Changed Type", each [Activity ID] = "ACT-Con-016")

    Don't worry, you just need to change the equal sign "=" into "<=", then you will have the expected outcome like below. 

     

    Reference: Filter by values in a column feature description - Power Query | Microsoft Learn

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PeteyG 

 

You can first duplicate the query, 

In the new query, filter rows by [Activity ID] column and select Equals... and set it to equal to ACT-Con-016. This will give you the formula like below in the formula bar and remain only one row in the outcome. 

= Table.SelectRows(#"Changed Type", each [Activity ID] = "ACT-Con-016")

Don't worry, you just need to change the equal sign "=" into "<=", then you will have the expected outcome like below. 

 

Reference: Filter by values in a column feature description - Power Query | Microsoft Learn

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!