Forum Discussion

DPCCGF's avatar
DPCCGF
Icon for Helper IV rankHelper IV
3 years ago

DAX If Statement with Unrelated Table

Hi all, I have two tables, one called Call for Services and one called Shift.  The Call for Services, each record, has a Department (there are 26 departments).  The Shift table has all the Department...
Need Help
Show and Tell
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
3 years ago

it looks like a date type issue, change it to a time only field

DPCCGF's avatar
DPCCGF
Icon for Helper IV rankHelper IV
3 years ago

The error, if I return Agency it works.  If I return Dispatch Time it works, if I return Shift I get the error which is shown below.  I really appreciate your help.