Calculate production time*quantity

Hi evadung ,

It seems that you want to retreieve the Production Time in second table based on Date if it falls within start date and end date of First Table.

So, You can follow below steps to achieve your requirement.

1. Create a column in Second table with below DAX expression:

FinalCalculation =

var sampledate = 'Table Second'[Date].[Date]

var productiontime =

    CALCULATE (

       MIN('Table'[Production time]),

        FILTER (

            'Table',

            'Table'[Start date].[Date] <= sampledate

                && 'Table'[End date].[Date] >= sampledate && 'Table Second'[Item] = 'Table'[Item]

        )

    )

    return productiontime*'Table Second'[Quantity]

Please refer to the below screenshot for the same.

This will give below output,

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at [email protected]

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/