The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
31 | |
12 | |
10 | |
10 | |
9 |