Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
Hi @RaphaelAlves ,
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
= Table.SelectRows(#"Name of Previous Step", each [Column1] = DateTime.LocalNow())
Technically it returns a Date/Time value, where TODAY() returns a Date value. The literal closest to TODAY() is Date.From(DateTime.LocalNow()) which you should use rather than DateTime.LocalNow() alone if the column you're filtering is already a plain date type rather than date/time.
Proud to be a Super User!
Hi @RaphaelAlves ,
If your data is date type not date/time one, Then we should use DateTime.Date(DateTime.LocalNow()) to work on it.
Btw, M code for your reference.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwtNQ3NNA3MlaK1YFxDYEIwTUwBCJUrpFSbCwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [DATE = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"DATE", type date}}), #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([DATE] = DateTime.Date(DateTime.LocalNow()))) in #"Filtered Rows"
I was trying to do something similar and the logic or syntax may apply. I was trying to limit my TCdate (timecard date) to any date prior to today. I used this in Power Query and it worked: = Table.SelectRows(#"Filtered Rows", each [TCdate] < List.Max(#"Filtered Rows"[TCdate]))
Hi @RaphaelAlves ,
Just click on the top of the column on the down arrow, your filter selection will come up. Choose there.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @RaphaelAlves ,
Tell me what an ODS table is? It sounds like you are trying to filter before it gets to Power Query. Is that right? If so I cannot help you. If that is the case you would be better off to post again, and describe that.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @RaphaelAlves ,
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
= Table.SelectRows(#"Name of Previous Step", each [Column1] = DateTime.LocalNow())
Technically it returns a Date/Time value, where TODAY() returns a Date value. The literal closest to TODAY() is Date.From(DateTime.LocalNow()) which you should use rather than DateTime.LocalNow() alone if the column you're filtering is already a plain date type rather than date/time.
Proud to be a Super User!
Hi @RaphaelAlves ,
If your data is date type not date/time one, Then we should use DateTime.Date(DateTime.LocalNow()) to work on it.
Btw, M code for your reference.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwtNQ3NNA3MlaK1YFxDYEIwTUwBCJUrpFSbCwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [DATE = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"DATE", type date}}), #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([DATE] = DateTime.Date(DateTime.LocalNow()))) in #"Filtered Rows"
And I just say that because of how the forum works.
Proud to be a Super User!
Hi Nathaniel ... I am not sure if this is the right thread for my questoin .. .but perhaps you can help? When I get data into Power BI I see that the date created date is based on some other time zone ... in my case about 9 hours behind .. which means when 'getting data' I can't use the Date Created filter as the times are not correct.
Can you tell me how to set this to my particular time zone?
thanks
Marc
Hey @MarcUrdang ,
If I understand your question, here is a good video that will take you through the steps Ruth at Curbal
Thank you,
Let me know if you have any questions.
Proud to be a Super User!