Filter Table by Date

[Yink88]

I want to be able to count the rows of my table after a certain day (5/10/2022). I have a "Date Created" column and nothing is working for me.

[Vijay_A_Verma]

Insert following formula in PQ to count rows where #"Changed Type" should be replaced with your previous step

= Table.RowCount(Table.SelectRows(#"Changed Type", each [Date Created] > #date(2022, 5, 10)))

 See the working here - Open a blank query - Home - Advanced Editor - Remove everything from there and paste the below code to test

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtU31jcyMDJSitUBcSyQOYYGKDwjZJ6RJYJnhmyGmb6hKYJnrm8I5cQCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Date Created" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date Created", type date}}),
    #"Filtered Rows" = Table.RowCount(Table.SelectRows(#"Changed Type", each [Date Created] > #date(2022, 5, 10)))
in
    #"Filtered Rows"

If you are looking for DAX solution

Count of Rows = COUNTROWS(FILTER('Table','Table'[Date Created]>DATE(2022,5,10)))