TreatAs is useful for filtering, plus it does not filter just considering one column, it could filter predicated on as much as columns you prefer. One of several challenges in Power BI relationships is creating a relationship according to numerous industries, we have formerly explained a technique you can make use of to produce a compound key and use that for the relationship. Another technique is to utilize TreatAs. LetвЂ™s see how TreatAs might help for the reason that situation.
This will be for Training, Not Advice
Because i acquired plenty of concerns from my very first article about TreatAs, i do want to make clear one thing right here before we begin;
Although we explained in the earlier post that you could produce a digital relationship making use of TreatAs, as well as in this post, i will be describing how exactly to produce a relationship centered on numerous industries making use of TreatAs, These particular usage cases shouldn’t be regarded as my suggestion. I recently explain these for the true purpose of TRAINING. You can find, of course, usage cases to utilize TreatAs, nonetheless, this post together with previous post is simply going to explain the way the function works, therefore I adhere to easy, and easy to comprehend examples.