Trade Data and Leave Data analysis

[Abhay]

Hi

I have Trade Data and Employee leaves data with following tables in the data Model.

I have attached file here - https://www.dropbox.com/s/v20we9pdql...ysis.xlsx?dl=0

1. Employee Data - Employee ID and Employee Name
2. Employee Leaves - Leave Start Date, End Date, Days and Employee ID
3. Trade Data - Trade Date, CUSIP #, Employee ID

Table 2 and 3 are related to Table 1 with Employee ID.

4. Calendar - I have one year Calendar table for 2015.

Leave table is linked to calendar with Start Date and Trade data is linked to calendar table with Trade date.

My objective is here to check if there was any trade being booked from employee id when he / she was on leave.

Thank you in advance for your help.

 

[NARAYANK991]

Hi Abhay ,

See the file.

https://www.dropbox.com/s/jujfep5n8tj1i5o/Trades Analysis.xlsx?dl=0

Narayan

 

[Abhay]

Hi Narayan,

Thanks for your response and sorry for late reply from my side.

I was aware about CountIfs but I am looking at option in PowerPivot - DAX since I will have multiple slicers on which I need to perform analysis. And using Countifs it will be very complex and slow.