Excel Jason
New Member
- Joined
- Oct 17, 2022
- Messages
- 26
- Office Version
- 365
- Platform
- Windows
Hello,
I have a DAX formula that's essentially performing two calculations; However, although both work separately, when combined the second formula seems to over-write the second.
The desired outcome: If Project Name = "OKC to FLC" check for the two stated service provides and result a "Y" or "N". IF NOT, perform an identical check for the "MID to JAL' project name and return a "Y" or "No". If a given line item does not fit in these two buckets, return a blank.
What I'm receiving is a result is correct "Y" and "N" separation for "MID to Jal" but the first logical check for "OKC to FLC" returns blanks when it should return a "Y" or "N".
I think some syntax error is over-writing the first logic and only returning the second. Thoughts?
I have a DAX formula that's essentially performing two calculations; However, although both work separately, when combined the second formula seems to over-write the second.
The desired outcome: If Project Name = "OKC to FLC" check for the two stated service provides and result a "Y" or "N". IF NOT, perform an identical check for the "MID to JAL' project name and return a "Y" or "No". If a given line item does not fit in these two buckets, return a blank.
What I'm receiving is a result is correct "Y" and "N" separation for "MID to Jal" but the first logical check for "OKC to FLC" returns blanks when it should return a "Y" or "N".
I think some syntax error is over-writing the first logic and only returning the second. Thoughts?