Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
jmusayon
New Member

How to set a date range

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.

1 ACCEPTED SOLUTION
DataInsights
Super User
Super User

@jmusayon,

 

Try replacing the code in red with this:

 

DateTime.LocalNow()

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

5 REPLIES 5
v-sgandrathi
Community Support
Community Support

Hi @jmusayon,
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.

Hi @jmusayon,

 

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
Super User
Super User

Use this formula

 

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

DataInsights
Super User
Super User

@jmusayon,

 

Try replacing the code in red with this:

 

DateTime.LocalNow()

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@jmusayon,

 

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

 

DateTime.Date(DateTime.LocalNow())

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.