Tag: Data Modeling

Power BI Query Parameters: Optimizing Tables

Query parameters are a really strong feature in Power BI. There are many places that you can implement filters in Power BI, but on some occasions, it’s better to do this at the query layer versus the report level. You might want to create filters at the query level if you have massive tables from

Continue reading

Deep Dive Into The TREATAS Function – Virtual Relationships For Power BI

Deep Dive Into The TREATAS Function - Virtual Relationships For Power BI

In this example, I dive into one of the most advanced DAX functions in Power BI called TREATAS. If you can understand TREATAS, you’ll see that it has so many applications for you across all reports and dashboards which you might be creating inside of Power BI desktop. TREATAS will helps greatly in the simplification of

Continue reading

Measure Branching – The Most Important Concept When Using DAX In Power BI

In this video tutorial I will run through what I feel is one of the most important development strategies or concepts to utilize within Power BI. I call it Measure Branching. The core idea with measure branching is that you start out creating calculations in Power BI with very simple measures. I sometimes refer to

Continue reading