Generate a date range to make a line between 2 dates

Hi Anonymous ,

Have you solved your problem?
If not, please try this way:
Use the DAX below to create a new table:

Date table = CALENDAR(MAX('Table'[Date start]), MAX('Table'[Date end]))

Then use the DAXs below to achieve your expected results:

Value = 
VAR A = SELECTEDVALUE('Table'[Quantity])
VAR B = CALCULATE(COUNTROWS('Date table'),ALLSELECTED('Date table')) - 1
RETURN
IF(
    'Date table'[Date].[Day] = 1,
    0,
    DIVIDE(A, B)
)

Value2 = 
VAR A = SELECTEDVALUE('Table'[Quantity])
VAR B = CALCULATE(COUNTROWS('Date table'),ALLSELECTED('Date table')) - 1
VAR C =
IF(
    'Date table'[Date].[Day] = 1,
    0,
    DIVIDE(A, B)
)
VAR D = 'Date table'[Date].[Day] - 1
RETURN
C * D

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.