top of page

KNOWLEDGE HUB
Practical explanations for better data work
Articles on Excel, Power BI, Power Query, dashboards, and automation—kept focused enough to use in your next project.


Power BI Full-Text Search with DAX: TEXTCONTAINS and TEXTSIMILARITY
Learn how Power BI’s September 2026 full-text search preview works. Configure a persisted column index, find matching feedback with TEXTCONTAINS, rank it with TEXTSIMILARITY, and avoid common setup and scoring mistakes.

MirVel
1 hour ago7 min read


Power BI: Relationships in Models – The Ultimate Guide
Introduction Building effective Power BI reports is not just about loading data and creating visuals—it’s about structuring your data model correctly. Relationships are at the heart of that structure. In this post, we’ll explore what relationships in Power BI are, why they matter, how to create and manage them, and some advanced tricks to avoid common pitfalls. PRACTICE MATERIAL BELOW!👇 Understanding Relationships in Power BI Relationships define how tables connect with eac

MirVel
Sep 28, 20253 min read


The Ultimate Reusable DAX Measure Tool-Kit for Power BI
Power BI is a powerful business intelligence tool. The DAX (Data Analysis Expressions) language allows users to create custom calculations on data within the application. Whether you're a beginner or an advanced user, knowing the essential DAX measures is crucial for effective data analysis. This blog post will explore a 'must-have package' of DAX measures that can be reused across various datasets. We will start from basic measures such as SUM, COUNT, and AVERAGE, and move t

MirVel
Jul 27, 20254 min read
bottom of page
