Power BI

You have lost your column types in Power Query and want to get them back? Check how easy it is to automatically detect and change all column types at once.

Currently I am working with a project where we extract data from a SQL server – some of the business logic is built into scalar value functions (documentation). Now the magic of PowerQuery enables …

Have you ever wished you could change multiple Power Query load destinations at once? Well now you can with Monkey Tools!

What is Progressive Disclosure? Progressive disclosure is an interaction design pattern that sequences information and actions across several screens (e.g., a step-by-step signup flow). The purpose is to lower the…

This article describes how to use conditional formatting with a DAX expression to color the rows of a table in Power BI based on the order number instead of

If you have ever wanted to refresh selected or multiple tables in Power BI desktop, but not ALL the tables this blog post explains how to achieve this.

<p>Cerner Corporation implements a single source of truth for data</p>

We’re pleased to announce the first Monkey Tools update is now available! A new feature, some new logic and an update to our Power BI connector.

We are working hard at Enterprise DNA to build a number of tools that can assist Power BI users in their development work. Today we are excited to announce the release of our DAX Clean Up Tool Why a new tool to format DAX formulas? One of the biggest hurdles that any Power BI user faces when they start developing reports and dashboards is attempting to understand how DAX formulas and DAX code work. WeContinue reading

BeComments - Add your comments to your Microsoft Power BI report and link it with your data! Add formatted text, images and even videos!

Recursive functions in Power Query are not very popular, but sometimes very helpful when in need. In this post, I'll explain what a recursive function is, how it works, and explain it through a famous recursive example of Fibonacci Sequence. Fibonacci Sequence Fibonacci sequence is one of the fundamental recursive operations in math, below are…

This blog post demonstrates the how to steps to create calculation groups which can be used to display multiple measures and format strings in Power BI

Dynamically retaining only columns that contain Actual values from a Table This article is part 3 of the Using Power Query lists series. In this series, we will look at how we can use lists to do the following: Dynamic Filtering on a Column Using Lists Changing a Table of Attributes and Values to retain […]

A quick post today. Sometimes you will be mystified why your aggregations are not getting hit. There is no clear-cut answer to why. The best way to find the underlying...

Today we’re releasing the second edition of the Power Platform Adoption Framework. We're introducing some new ideas—and new ways of thinking about existing concepts—as we enter the Power Platform Adoption Framework's second year. As a "framework", we're committed to broadly applicable best

The Accounting and Finance community deals with high volumes of sensitive and confidential information. As such, reporting which enables everyone within an organisation to see only the information they are authorised to see is of importance to this community. Leveraging the Row Level Security and ...

When you have a tool that can carry out up to 380 data transformations, mostly through simple GUI clicks, then the tool is not ordinary. That explains why Power Query, originally born in Excel, is now a powerful engine in many other tools (Power BI, Power Automate, CDS, Azure Analysis Services, ma...

Theory If you just want to see read/write XMLA endpoints in action, skip to the Practice session. Otherwise, if you never heard of it or just wanna read up on the specifics, keep reading here and we'll get there eventually Preview Feature To start with a side-note disclaimer: XMLA Endpoint If ...

For someone utterly new to Power BI, and especially for those who have been using Excel, understanding DAX can be an overwhelming experience. At least, it was for me. It took me some time to grasp the concepts, filter and row contexts, and the CALCULATE function. One of the standard requirement...

Objective: We would like to have WTD(Week Till Date) Last WTD and This Week vs Last Week. Dataset: We have taken Sales data. The data is from April 2018 till April 2020. We have created a date Calendar. Steps: We create a Date Calendar With Monday to Sunday Week, with the following week-related...

We’re pleased to announce the first Monkey Tools update is now available! A new feature, some new logic and an update to our Power BI connector.

Slabs or tired calculations are common in income taxes or commission rates. Learn to do slab or tried calculations using DAX in Power BI

Utilizing Power Query Lists 2/3 This article is part 2 of the Using Power Query lists series. In this series, we will look at how we can use lists to do the following: Dynamic Filtering on a Column Using Lists Changing a Table of Attributes and Values to retain only Top 10 Attributes (by values) […]

Power BI incremental refresh is a very powerful feature and now it’s available in Shared capacity (not just Premium) everyone can use it. It’s designed for scenarios where you have a da…