Forum Discussion
Filter by maximum date
Hi, I am pulling data that includes data from many weekly instances/data cuts. For each record I have fields that tell me the data cut's fiscal year, fiscal period and fiscal week (within the fis...
Hi PowerWhy ,
Consider filtering out the largest fiscal year first:
= Table.SelectRows(PreviousStepName, each [Fiscal Year] = List.Max(PreviousStepName[Fiscal Year]))
Then filter out the records equal to the largest Fiscal Week.
= Table.SelectRows(PreviousStepName, each [Fiscal Week] = List.Max(PreviousStepName[Fiscal Week]))
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum