How do i add days from a measure to a date?

[Vitorino]

Hello community,

How can i add calculated days from  a measure  to a date?

i Have a buy date, a sell date and seller. 

I want to add for each transaction that doesn't have a sell date, the avg number of days each seller takes to sell that product, in a column that calculates the expected time to sell in days:

[v-xiaosun-msft · Accepted solution]

Hi @Vitorino ,

According to your description, it seems that your [sell_time(days)] is a measure. Since measures themselves come with their own calculation logic, I think that you can use calculated column to return sell_time(days) to calculate the average, and then user another calculated column to return your expected output.

Since you didn't provide whole sample data, I made a sample and here are steps.

Create two columns.

sell_time(days) =
IF (
    'Table'[sell date] = BLANK (),
    DATEDIFF ( 'Table'[buy date], DATE ( 1899, 12, 30 ), DAY ),
    DATEDIFF ( 'Table'[buy date], 'Table'[sell date], DAY )
)

Expected_time_to_selldays =
IF (
    'Table'[sell date] = BLANK (),
    AVERAGEX (
        FILTER (
            'Table',
            'Table'[sell date] <> BLANK ()
                && 'Table'[seller] = EARLIER ( 'Table'[seller] )
        ),
        'Table'[sell_time(days)]
    )
)

Final output:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ xiaosun

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