Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I'm trying to create a dynamic table in Power Query that makes a list of dates from a predetermined date to today. Currently, I have an equation that simply adds a set amount of days to a date. Is there a way for me to write a formula to do that dynamically, given today's date and a given begin date?
Conceptually, I want to do something like today() - date, and then insert that value into my forumla before...but I'm too inexperienced with the notation to do it.
Important - I need to do this in Query because I am merging a bunch of tables before loading the table.
Example Below:
Solved! Go to Solution.
HIi @Anonymous
List.Dates(#date(2019,10,01),Number.From(Date.From(DateTime.LocalNow())-#date(2019,10,01))+1,#duration(1,0,0,0))
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
HIi @Anonymous
List.Dates(#date(2019,10,01),Number.From(Date.From(DateTime.LocalNow())-#date(2019,10,01))+1,#duration(1,0,0,0))
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |