Forum Discussion
Need Help Combining multiple Power BI formulas
ah, ok - I was able to figure out something else that seemed to do the trick!
The VAR / RETURN construct is handy if you need to calculate (read: Measures) something multiple times in a complex calculation. You can define it once, then reference it multiple times in the body, saves you from having to calculate it each time the formula comes across it :).
Does not really help you here.
So what happens if you build the IF statement one element at a time? Or build it off other calculated columns?
So that's part of the problem I keep running into - I want to build formulas off of the calculated columns that I've built, but they won't show up as one of the columns to work off of, so I keep having to find ways to combine the formulas from all of the calculated columns I've created. I don't know if I'm missing a step to link those columns back into the data?