Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
Solved! Go to Solution.
Try replacing the code in red with this:
DateTime.LocalNow()
Proud to be a Super User!
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.
Use this formula
= List.Dates(#date(2024,1,1),Number.From(Date.From(DateTime.LocalNow())- #date(2024,1,1))+1,Duration.From(1))
Try replacing the code in red with this:
DateTime.LocalNow()
Proud to be a Super User!
Does your date field have a time portion? It may be simpler to use a date rather than a datetime:
DateTime.Date(DateTime.LocalNow())
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
15 | |
14 | |
13 | |
12 | |
11 |