Forum Discussion
stuieb
6 years agoFrequent Visitor
Multiple Queries
Hi Could someone please help. I'm new to PowerBI. I'm using to reporting with Excel, SQL, (and C# if some complicated stuff was ever needed). I'm bringing in an Opportunities table from Sal...
stuieb
6 years agoFrequent Visitor
Thanks for replying.
The HR hire/fire is a correct analogy. I'll look closer, at the moment it's not clear where those calculations need to reside and why one relationship is active and the other inactive.
This is very different from SQL... it's frustrating.
amitchandak
Super User
6 years agoDAX works in a different way. Two tables can have only one active relation. More than one relation is like an alias. You need to choose join means alias in the formula.