Summarize Average Date by Batch Number and Movement Type

Hi Anonymous ,

Based on the information, try using the following DAX formula to calculate the date.

Measure1 = 
VAR FirstPosting =
    CALCULATE(
        FIRSTDATE(TEST[Posting Date]),
        TEST[Movement Type] = "901",
        TEST[Plant] = "FRPB"
    )
VAR LastPosting =
    CALCULATE(
        LASTDATE(TEST[Posting Date]),
        TEST[Movement Type] = "901",
        TEST[Plant] = "FRPB"
    )
VAR MidPosting =
    FirstPosting
        + INT(DATEDIFF( FirstPosting, LastPosting, DAY ) / 2)
RETURN
    MidPosting

Measure2 = 
VAR FirstPosting =
    CALCULATE(
        FIRSTDATE(TEST[Posting Date]),
        TEST[Movement Type] = "68C",
        TEST[Plant] = "FRAA"
    )
VAR LastPosting =
    CALCULATE(
        LASTDATE(TEST[Posting Date]),
        TEST[Movement Type] = "68C",
        TEST[Plant] = "FRAA"
    )
VAR _date =
    FirstPosting
        + INT(DATEDIFF( FirstPosting, LastPosting, DAY ) / 2)
RETURN
    _date

Measure days = DATEDIFF([Measure1], [Measure2], DAY)

Then, drag the measure to the card visual.

Best Regards,

Wisdom Wu

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