Welcome to the Power BI Community Blog!

On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news.

Multivalued column is a database design pattern where instead of normalizing and splitting data across multiple tables you keep multiple values in a single column. When used, this pattern requires extra modelling to work great in Power BI. This article explains how to do it!

Read more...

Power BI Desktop: Custom Aggregations, Formatting and Performance Indicators (Part 1)

by Dianapo Visitor on ‎02-20-2018 04:46 PM - last edited on ‎04-03-2018 10:16 AM by Administrator MindyJ

This multi-part tutorial blog is geared to help BI Analysts create versatile Scorecards with KPIs as well as to facilitate the business reporting transition from Excel, SSRS or other apps to Power BI Desktop.

 

In this initial installment, I will illustrate how to include more than one aggregation and custom formatting in the Power BI Desktop Matrix. All tutorial steps below require acquaintance with how Power BI Desktop works as well as basic to advanced DAX skills.

Read more...

Walk Through Of Many Ranking Techniques using DAX in Power BI

by EnterpriseDNA Regular Visitor on ‎10-09-2017 01:49 PM - last edited on ‎10-09-2017 01:50 PM by mbenjamin Member

There's so many applications and situations where utilising ranking techniques really add a lot of value in your analysis.
 
I've created many videos over at Enterprise DNA TV which showcase these techniques, so I thought I might review some of these here so you can learn about them more.
 
I'm going to review these techniques but don't forget you could apply these a number of different ways and in lots of situations.
 
1. Find Your Top Customers Through Time Using RANKX in Power BI w/DAX
2. Discover Top Salespeople Contribution To All Sales in Power BI w/DAX
3. Discover The Best Selling Day For Your Products w/DAX in Power BI

 

Enterprise DNA TV logo2.png

Read more...

Using DAX to compare data or metrics over time is incredibly efficient. Using a range of techniques in this post I'll show you how to analysis performance of these metrics over multi-year time periods.

 

Multi Year Performance Analysis.JPG

Read more...

It is amazing how much more efficient it is to complete reasonably technical analysis with Power BI. One business scenario where this will bring huge value to an organisation is when looking to understand your customers better.

Read more...

One type of analysis I like to use quite often is comparing this year totals to last year totals. I want to also always make it as dynamic as possible. All I should have to do is change the context of my calculation (ie. bring in a new dimension like regions/products etc) and everything should automatically re-calculate.

Read more...

Attachment
Join Blog
Interested in blogging for the community? Let us Know.