How to set a date range

[Anonymous]

Hi, 

I hope someone can help me to solve this. I want to set a date range since 2024-01-01 to current date. I tried with this code but it doesn´t work. 

= Table.SelectRows(ConjuntoDeDatosConFaseTemporalDeLaAsignación_table, each [Día] >= #datetime(2024, 1, 1, 0, 0, 0) and [Día] <= #datetime(Date.Year(DateTime.Date), Date.Month(DateTime.Date), Date.Day(DateTime.Date), 0, 0, 0))

The code in blue works.

= Table.SelectRows(ConjuntoDeDatosConFaseTemporalDeLaAsignación_table, each [Día] >= #datetime(2024, 1, 1, 0, 0, 0) and [Día] <= #datetime(2025, 01, 10, 0, 0, 0))

Thanks.

[v-sgandrathi]

Hi @Anonymous,
Thank you for reaching out to the Microsoft Fabric Community forum.

I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.

If you have any further questions or updates regarding your issue, feel free to ask, and we will look into that.

Regards,
Sahasra.

[v-sgandrathi]

Hi @Anonymous,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you for being a part of the Microsoft Fabric Community.

[Omid_Motamedise]

Use this formula

= List.Dates(#date(2024,1,1),Number.From(Date.From(DateTime.LocalNow())- #date(2024,1,1))+1,Duration.From(1))

[DataInsights · Accepted solution]

@Anonymous,

Try replacing the code in red with this:

DateTime.LocalNow()

[DataInsights]

@Anonymous,

Does your date field have a time portion? It may be simpler to use a date rather than a datetime:

DateTime.Date(DateTime.LocalNow())