There is no reason you cannot use two comparisons in a calculated field. So, there is likely some other issue with the calculated field--what error are you receiving?
Did you see the excel spreadsheet I attached. I'm not receiving an error the calculated field works just fine, but it doesn't give me what I need. I can't figure out how to get the table to show MTD, QTD and YTD for various metrics rather than just one.
What work around did you use to achieve this?