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.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |