WELCOME TO

Excelized -
Your Data Playground

Get ready to dive into the exciting world of data with Excelized!

Free Consultations

Check Blog for the latest news & updates

Mastering DAX Queries in Power BI: Structure, Logic & Best Practices

Introduction Ever wondered what happens behind the scenes when you drag a visual into Power BI? That’s DAX queries at work. While most users write DAX formulas to calculate measures or columns, DAX queries go one level deeper — they let you directly query your model, test logic, and debug calculations.In this post, we’ll break down what DAX queries are, how they work, their structure, examples, pitfalls, and best practices — plus a few pro tricks to level up your Power BI

Admin

Nov 185 min read

SharePoint.Files vs SharePoint.Contents in Power Query: Which One Should You Use?

Overview When you connect Power Query / Power BI to a SharePoint site (or document library), there are (at least) two common M-functions you may see or use: SharePoint.Files(siteUrl as text, optional options as record) as table SharePoint.Contents(siteUrl as text, optional options as record) as table Although they sound similar, their behavior, performance, metadata returned, and navigation experience differ. Understanding their differences helps in building more robust and p

Admin

Nov 96 min read

Data Types in Power Query vs. Data Types in Power BI’s Table View (Canvas)

Hook: If your model “mysteriously” changes numbers, breaks relationships, or sorts months alphabetically—blame data types. What we’ll cover: where to define types (and why), the safest order of operations across the ETL chain, Power Query vs. Model vs. Table View, special cases (DirectQuery, currency, duration), and concrete, copy-paste examples. 1) Why data types matter (and where they live) Power Query (PQ): Data shaping stage. Types here affect folding, transformations

Admin

Nov 25 min read

2 3 4 5

Discover More

About Excelized

Your Data Playground

Get ready to dive into the exciting world of data with Excelized!
Whether you’re a curious beginner, a seasoned data pro, or somewhere in between – you’re in the right place when it comes to data analytics, automation, reporting, and ETL.

With fresh insights, hands-on tutorials, and practical everyday tips, we help you master Microsoft’s power trio:
Excel, Power BI, and Power Automate – the ultimate tools to level up your data game!

At Excelized, we make complex data processes feel effortless. Whether it’s dynamic dashboards, automated workflows, or custom calculators – we’ll show you how to turn raw numbers into smart, visual, and impactful stories.

Quick Fix
Use when: You need a fast solution to a specific Excel / Power BI / Power Automate issue.
Read More
99 euros
Learn More
Custom Project
Use when: You need end‑to‑end analytics: modeling, RLS, governance, automation, reports.
Read More
Price negotiable
Learn More
Free Consultation
Meet and greet!
Read More
Learn More