I have two data sources. Once is an Excel file and one is a SQL. The Excel file has the data I need to analyze. The SQL file has all dates from 1900 - 2050 and has a 'Yes/No' dimension which allows you to only see business days. I created the following DATEDIFF calculation to determine the number of days between start and finish: DATEDIFF('day',[Date Start],[Date End] )
I created a relationship between my excel Date End field and the SQL date field, then I dragged the IS BUS DAY to the filter and selected yes. The data no longer displayed. Please help!