Power Bi

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,...

Advanced Time Intelligence in DAX with Performance in Mind

Everyone knows the standard Time Intelligence function based on years, quarters, months, and days. But sometimes, we'd like to perform more exotic timer intelligence calculations. But we should always not forget to think about performance...

Recent posts

Popular categories

ASK ANA