Summary Column by End of Week

[Anonymous]

Hello,

I'm trying to calculate a column that will summarize [SUMMARY] hours by End of Week.  There could be a number of PAY TYPES.

SAMPLE TABLE

EMP ID

DATE               

HOURS 

PAY TYPE       

END OF WEEK 

SUMMARY

1	8/22/2021	0	Regular	8/28/2021	40
1	8/23/2021	8	Regular	8/28/2021	40
1	8/24/2021	8	Regular	8/28/2021	40
1	8/25/2021	8	Regular	8/28/2021	40
1	8/26/2021	8	Regular	8/28/2021	40
1	8/27/2021	8	Regular	8/28/2021	40
1	8/28/2021	8	Overtime	8/28/2021	8

Thanks in advance! 

[Ashish_Mathur]

Hi,

This calculated column formula works

=CALCULATE(SUM(Data[HOURS]),FILTER(Data,Data[END OF WEEK]=EARLIER(Data[END OF WEEK])&&Data[EMP ID]=EARLIER(Data[EMP ID])&&Data[PAY TYPE]=EARLIER(Data[PAY TYPE])))

Hope this helps.

[Anonymous]

Desired output: 

[ryan_mayu]

@Anonymous 

could you pls provide some sample data?

[Anonymous]

I hope this helps....

[ryan_mayu]

@Anonymous 

I am confused about this. I have seen this in your prevous reply. Is this your sample data or expected output?  If this is the sample data, could you pls provide the expected output?

[Anonymous]

The expected output is the SUMMARY column. 

[ryan_mayu · Accepted solution]

@Anonymous

pls try to create a column

Column = CALCULATE(sum('Table'[hours]),ALLEXCEPT('Table','Table'[EMP ID],'Table'[Pay type],'Table'[end of week]))

[amitchandak]

@Anonymous , the expected output is not clear

[Anonymous]

Apologies, formatting error.  Screenshot below: