DAX Query

[aravinthets]

Hi All 

     i need your help to solve the following report query.

I have a employee time log data,from that i need to prepare monthly attendance report.

https://drive.google.com/file/d/1nu2damM4PXcRrsObSTDGW5Wo3JL13a0H/view?usp=sharing 

The data contains the following information

1. Date

2.Employee Name

3.Activity Code

4.Start time

5.End Time

6.Total Hrs

Note :

1.Employee leave also captuer in the time log by selectingactivity code as "Leave"

2.Half day leave also available

3.Employee may enter multiple time slot for a single day

4.want to show total number of working days in one column

5.If there is no time log for the day except sunday then it should mark as absent

[TomMartens]

Hey @aravinthets ,

what you want is not totally clear, at least not to me. Please take the time and prepare sample data. Upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data, share the xls as well.

Describe your expected outcome based on the sample data you provide.

Regards,

Tom

[aravinthets]

Hi Tom

     Thanks for your email. Herewith I have attached a excel sheet which contains input sheet and expected result sheet.

Thanks

Aravinth Thttps://drive.google.com/file/d/1nu2damM4PXcRrsObSTDGW5Wo3JL13a0H/view?usp=sharing