Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone,
New Power BI user here!
I have a table that contains this construction data:
I want to creat a new date table that has dates in between the start and finish dates.
Example:
I want to use this table to creat a visual like this, but with a much smoother curve.
Any help would be appriciated!
Solved! Go to Solution.
@Jacob_Fetter , Refer
DAX Dynamic - https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...
DAX new table - Attached file -
Power Query - Get Dates between ranges using Power Query: https://youtu.be/SFEPsKfqIks
@Jacob_Fetter , Refer
DAX Dynamic - https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...
DAX new table - Attached file -
Power Query - Get Dates between ranges using Power Query: https://youtu.be/SFEPsKfqIks
Thank you for providing me with those materials! I was able to get the result I wanted by using them.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
10 | |
10 | |
9 | |
7 |