How To Solve a Complex DAX Problem
I was helping someone on Power Pivot Forum last week with a tricky calculated column question. As an aside, you may know that I always advise beginners to keep away from calculated columns. You mostly don’t need calculated columns because in most circumstances a measure is a better option to use (read more about that here). On this occasion however the required formula is likely to be complex, the run-time performance of such a formula as a measure could be slow, plus the number of possible unique values from the DAX Formula is small. When these conditions are present, a calculated column can be a good solution.