Forum Discussion

martijnth's avatar
martijnth
Helper II
7 years ago
Solved

Selecting Dates in Shift based data file

Dear Reader, i'm stuck on the following. I have a data file with production time date (pieces), now i want to filter out the total amounts of the last shift. It is a 4 shift continous system sometin...
Need Help
Show and Tell
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    martijnth,

     

    Based on your description, you may modify calculate column like pattern below:

     

    test =
VAR result =
    CALCULATE (
        MAX ( TBM_PRODUCTION_DATA[Date + Shift NUM] ),
        FILTER (
            TBM_PRODUCTION_DATA,
            TBM_PRODUCTION_DATA[This Year] = 1
                && RELATED ( MES_Profile[Shift] ) = "A"
        )
    )
RETURN
    IF ( ISBLANK ( result ), result, "Unreported" )

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

martijnth,

 

Based on your description, you may modify calculate column like pattern below:

 

test =
VAR result =
    CALCULATE (
        MAX ( TBM_PRODUCTION_DATA[Date + Shift NUM] ),
        FILTER (
            TBM_PRODUCTION_DATA,
            TBM_PRODUCTION_DATA[This Year] = 1
                && RELATED ( MES_Profile[Shift] ) = "A"
        )
    )
RETURN
    IF ( ISBLANK ( result ), result, "Unreported" )

Regards,

Jimmy Tao