One of the most common types of banding or binning is banding based on a range. Let’s say, for example, you want to have a group of customers based on their age group. The age group banding can be created in Power Query at the data transformation stage. It can be created using the Grouping Read more about Age Banding in Power BI Using TREATAS DAX Function – Relationship Based on Between[…]
TreatAs is helpful for filtering, and it doesn’t filter only based on one column, it can filter based on as many as columns you want. One of the challenges in Power BI relationships is creating a relationship based on multiple fields, I have previously explained a method you can use to create a compound key Read more about Creating Relationship Based on Multiple Fields in Power BI Using TREATAS DAX Function[…]
TreatAs is an interesting function with multiple use cases in Power BI. I thought it is good to explain it in a set of articles, the first one here is about what the TreatAs function is and how it can help to build filters and a virtual relationship between two tables. Let’s see how you Read more about Building a Virtual Relationship in Power BI – Basics of TREATAS DAX Function[…]