Forum Discussion
Resolver IEdit Queries - Create a new column to identify latest date based on criteria
hi, danb
You could try this way as below:
Step1:
Duplicate the basic table.
Step2:
Use Group By function in edit queries as below for duplicate table
Step3:
Now, merge the basic table and this new table
Step4:
Expand Lastest Date column
Now you could add a custom column for filter as below:
here is my sample pbix file, please try it.
Best Regards,
Lin
Community Supporthi, danb
You could try this way as below:
Step1:
Duplicate the basic table.
Step2:
Use Group By function in edit queries as below for duplicate table
Step3:
Now, merge the basic table and this new table
Step4:
Expand Lastest Date column
Now you could add a custom column for filter as below:
here is my sample pbix file, please try it.
Best Regards,
Lin
danbv-lili6-msft - this works great and you actually showed me how to simplify the approach. I originally was thinking I needed some type of flag column to filter out certain rows however simply grouping the data in the original table gets me to what i need. Many thanks again!
Dan