Forum Discussion
emembreno81
4 years agoFrequent Visitor
Need Help Combining multiple Power BI formulas
hello! I'm working on a report that is based off of a direct connect to an existing Power BI dataset. I'm building new columns of data so that I can filter the information down and provide some ...
- 4 years ago
ah, ok - I was able to figure out something else that seemed to do the trick!
ToddChitt
4 years agoSuper User
Sounds like you are working with calculated COLUMNS, not MEASURES, correct? Are all these all in one table? What is the value of using the var _value / return _value structure? If each calculated column works OK, can you not reference it/them in the complex IF statement?
- emembreno814 years agoFrequent Visitor
Hello Todd - Yes, I am working with calculated columns and not measures. These are all in one table. I am only using the var_value/return_value structure because it was what was in the original "Invalid Color" formula - I don't know if it's actually required in this new formula