Shaping Dates into categories

Hi， Freeseman 

If possible, upload a sample file to cloud storage and share the link here.

Best Regards,
Community Support Team _ Eason

Thank you.

The data is a lot to share as i have many other tabes from other DB tables.

The way you explain to me is very good and helps me a lot. I just need to fix meassure calculation?

Hi, Freeseman 

I suspect this has something to do with the date slicers. 

Is 'Shift Date' a field in a separate calendar table?

Will the result of the current measure "Evening Shift Change" change with the value of slicer 'shift_date'?

After you clear the filter criteria for the date slicer, is the calculation result correct?

NS Lunch =
IF (
    MAX ( 'PRODUCTION'[TIMESTAMP (groups)] ) = "2. NS Lunch",
    CALCULATE (
        AVERAGE ( 'PRODUCTION'[PRODUCTION] ),
        FILTER (
            ALL ( 'PRODUCTION' ),
            'PRODUCTION'[TIMESTAMP (groups)] = "2. NS Lunch"
                && 'PRODUCTION'[Shift Date] IN VALUES ( 'PRODUCTION'[Shift Date] )
        )
    )
)

Best Regards,
Community Support Team _ Eason

Hi v-easonf-msft 

I tried to upload the file for you but its not allowing me.

I tried your new measure but same issue... i am not sure where it is taking this average from because i need the average of the 2 totals (0 and 23)

v-easonf-msft 

No Idea where it is getting 96.02 from

Hi v-easonf-msft , Struggle with company procedure.

Does this help

I have time stamps but the average is calculated per row and not per category?

v-easonf-msft I inbox you.

v-easonf-msft Please look. 🙂

I need help caterorising average per time category per day but also drag slider and need average over time.

https://1drv.ms/u/s!Ai_OAtss0EStcVjqwQTgXMKiFsw?e=auxUfP

Hi， Freeseman 

Sorry for later reply. The link seems to have expired, can you share it again?

Best Regards,
Community Support Team _ Eason