Forum Discussion
Need Help with converting an Excel Formula to Dax
Hello! I'm currently working to move a report that I currently run in Excel into Power BI. I'm currently working to convert a rather complex formula into DAX. Can someone help guide me on how t...
Hi Bruno!
So - I've actually now double checked the formula you provided and it looks like the OR functionality is not working in the formula your provided. It looks like the formula is excluding any case where both elements are not true where as I want it to look for instances where either one of the two portions of the formula are true. Do you know what may be causing that?
I have a feeling the formula is looking for instances where the data in the column is "tbd" ONLY - but I need to find instances where "tbd" is part of the information in the data. - so not just looking for "tbd" but also for example "tbd15" or "tbd blue"