I have an Excel file that is a list of Job Numbers considered "Projects"
I have a relationships created between the Job Numer of the Excel spreadsheet and a table from SQL called "JobSummary."
"JobSummary" is a table listing every job in the system.
I am trying to write measures but need to be able to only calculate data IF JobNumber in "JobSummary"= Job Number considered "Project"
I wanted to initially write is as a calculated column saying =IF(JobSummary[JobNumber]= ProjectJobs[JobNumber], "Project", "Not Project") but nothing works. BI won't recognize the ProjectJobs[JobNumber] as an option to put into the calculations