Power Bi

Learn how to Implement Three Use Cases for the Recent Calendar-Based Time Intelligence

Introduction about Time Intelligence in DAX up to now. Nonetheless, the brand new Calendar-based Time Intelligence feature rewrites the rulebook, as some concepts will change, and the required techniques will likely be simpler than before. Anyway,...

The Ultimate Guide to Power BI Aggregations

used a Composite model feature in Power BI, you would possibly have already heard about one other extremely necessary and powerful concept – Aggregations! It’s because in lots of scenarios, especially with enterprise-scale...

A Real-World Example of Using UDF in DAX

Introduction The feature of user-defined functions was introduced as a primary preview version with the September 2025 release. This feature enables us to encapsulate business logic in functions, which may be called like several other standard...

Every thing You Must Know In regards to the Recent Power BI Storage Mode

The aim of this text to offer the reply to the query: “Which one is ‘higher’ — Import or Direct Lake?” since it’s unattainable to reply, as there is no such thing...

What Is a Query Folding in Power BI and Why should You Care?

a question folding?” “Does your query fold?”… Perhaps someone asked you those questions, but you were like: “Query…Whaaaat?!” Or, possibly you’ve heard about query folding in Power BI, but didn’t know the right way...

Why You Should Not Replace Blanks with 0 in Power BI

watching Jeffrey Wang as a live stream guest with Reid Havens, and one in every of the dozen wonderful things that Jeffrey shared with the audience was the list of optimizations that the DAX...

How you can Reduce Your Power BI Model Size by 90%

First look under the hood — Formula Engine and Storage Engine First, I need you to fulfill the VertiPaq engine, “brain & muscles” of the system behind not only Power BI, but additionally Evaluation Services Tabular and Excel...

The Difference between Duplicate and Reference in Power Query

Introduction I may have to load the identical data twice into Power Query and subsequently into Power BI. This may occur when I have to split the information columns or perform other transformations on the information,...

Recent posts

Popular categories

ASK ANA