Quanto blog site - Quanto blog site

Dynamic buttons in Power BI (2)

Post author:Madzy Stikkelorum
Post published:May 2, 2023
Post category:Power BI
Post comments:0 Comments

In my previous blog post, I have shown you one method to create dynamic buttons in a Power BI visual report, resulting in a dynamic drill through page. In this…

Multiple role membership in Value Level Security

Post author:Michiel Rozema
Post published:March 29, 2023
Post category:Power BI
Post comments:0 Comments

For a few years now, we have worked with the concept of Value-level security (VLS). In short, VLS allows you to secure the visibility of not rows, as with Row-level…

Determining ISO Week Numbers in Power Query is Super Easy!

Post author:Michiel Rozema
Post published:March 17, 2023
Post category:Power BI
Post comments:0 Comments

If you are not in the US, chances are that your organization works with a calendar based on the ISO 8601 week numbering system. In the ISO standard, weeks…

Dynamic buttons in Power BI (1)

Post author:Madzy Stikkelorum
Post published:March 13, 2023
Post category:Power BI
Post comments:1 Comment

There are many ways to create a dynamic report in Power BI. A lot of the visuals that are available in Power BI also have a conditional formatting possibility to…

Linear regression in Power BI: the LINEST/LINESTX functions

Post author:Michiel Rozema
Post published:March 2, 2023
Post category:Power BI
Post comments:0 Comments

When analyzing large amounts of data, we are often interested in trends and correlations. One of the most basic methods to research these, is linear regression. Linear regression is a…

ALLSELECTED() and Report Page Tooltips

Post author:Michiel Rozema
Post published:February 16, 2023
Post category:Power BI
Post comments:0 Comments

The DAX function ALLSELECTED is a powerful function that accomplishes something that cannot be done otherwise. The simple version of what ALLSELECTED does, is this: like other ALL functions,…

From Excel to Power BI: using normalized tables (3)

Post author:Henk Vlootman
Post published:January 18, 2021
Post category:Power BI
Post comments:0 Comments

In this third blog about achieving a different mindset when you want to change your business tools from Excel to Power BI. In the first blog I wrote about the…

From Excel to Power BI: using normalized tables (2)

Post author:Henk Vlootman
Post published:January 4, 2021
Post category:Power BI
Post comments:1 Comment

In this second blog about achieving a different mindset when you want to change business tools, I want to talk about the creating an extra numeric column as relation column…

From Excel to Power BI: using normalized tables (1)

Post author:Henk Vlootman
Post published:December 15, 2020
Post category:Power BI
Post comments:2 Comments

This blog is all about achieving a different mindset when you want to change business tools. If you used to work with Excel and want to take the path of…

AutoExist and the Case of the Missing Workdays

Post author:Michiel Rozema
Post published:November 23, 2020
Post category:Power BI
Post comments:0 Comments

This article is a follow-up to the AutoExists introductory post and one with an example on time intelligence based on workdays. In the latter, we created the month-to-date chart below,…