Forum Discussion

KevinMorneault's avatar
KevinMorneault
Helper II
1 year ago

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...
Need Help
KevinMorneault's avatar
KevinMorneault
Helper II
1 year ago

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)),

lbendlin's avatar
lbendlin
Super User
1 year ago

cannot reproduce

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtY31DcyMDJWitWJVjJB5pgic8zgnFgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Current Renewal EndDate" = _t]),
    SourceWithDateType = Table.TransformColumnTypes(Source,{{"Current Renewal EndDate", type date}}),
    DebugSource = SourceWithDateType,
    #"Filtered Rows" = Table.SelectRows(DebugSource, each [Current Renewal EndDate] > #date(2023, 4, 1))
in
    #"Filtered Rows"