Forum Discussion
Fiscal Year
Hi All I have a query done in power query for the fiscal year, the query is working fine, i decided to add more criteria and did validation via copilot, which should be work. But for some reason...
This is the line which we have the issue
// Filter rows based on the date comparison
FilteredRows = Table.SelectRows(DebugSource, each [Current Renewal EndDate] > #date(2023, 4, 1)),
Please check that if you have error in date column,
If it has errors, it will display the information when you filter it.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.