Power BI: Use DAX to get relative dates

Patrick looks at how you can get relative dates, in Power BI Desktop, without using the relative date slicer or relative date filters. You just need to sprinkle a...

Basics of Modeling in Power BI: Fact Tables

Fact tables are the core of analysis in a data model. In the previous article, I explained what a dimension table is, and why we cannot have everything in...

Power BI Updates, tips and tricks and more… (May 13, 2019)

Power BI Performance Analysis

How can you find the cause of slow performance issues in Power BI? This post demonstrates some of the advanced tools you can you to test slowing performing queries...

Table and column references using DAX variables

This article describes how to correctly use column references when manipulating tables assigned to DAX variables, avoiding syntax errors and making the code easier to read and maintain. Using...

Power BI and The Matrix: A Challenge

The Matrix is one of the many built-in visualizations found in Power BI. While the Matrix is easy to populate, filtering it is not so straightforward. In this article, Dennes Torres explains how to add a slicer that does the job.

The BI Journey: The Expert’s Advice – Part 2

A BI project should return value to the company quickly, not only after months or even years of work. In this article by Gogula Aryalingam, Ruthie, the intern, determines which items from her manager's requirements she can complete before the big meeting. She continues working on her semantic model by including a Date table, the star schema, measures, formatting, and more.

Power BI and The Matrix: A Challenge

The Matrix is one of the many built-in visualizations found in Power BI. While the Matrix is easy to populate, filtering it is not so straightforward. In this article,...

Power Platform, Power BI Paginated, new Power BI Desktop and more… (April 15, 2019)

Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup133 2 Minute Tuesday: https://guyinacu.be/pbireportbuilder Patrick's tech video: https://guyinacu.be/kpicard Adam's tech video: https://guyinacu.be/newworkspace Sources MICROSOFT’S POWER PLATFORM...

Aggregations in Power BI

Aggregations have been introduced in 2018 in Power BI, as an optimization technique to manage large tables. By providing pre-aggregated tables, you can highly improve the performance of a...