Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 5 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 24 | |
| 11 | |
| 9 | |
| 7 | |
| 6 |