Replace calculated Column with calculated Measure with if conditions - DAX - Memory Issues

Before you do that ask yourself - can the result be impacted by users interacting with your reports?  If the answer is no, and the data is immutable, then you should not use a measure. If a calculated column is too slow or consumes too much memory then either optimize its code, or push it upstream and create that column in Power Query.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523