Skip to content
  • About Quanto
  • Sample Page
  • Quanto blog site

    Quanto blog site

    Determining ISO Week Numbers in Power Query is Super Easy!

    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…

    Continue Reading Determining ISO Week Numbers in Power Query is Super Easy!
    Linear regression in Power BI: the LINEST/LINESTX functions

    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…

    Continue Reading Linear regression in Power BI: the LINEST/LINESTX functions
    ALLSELECTED() and Report Page Tooltips

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

    Continue Reading ALLSELECTED() and Report Page Tooltips
    AutoExist and the Case of the Missing Workdays

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

    Continue Reading AutoExist and the Case of the Missing Workdays
    Let’s enjoy the weekend – workday analysis with DAX

    Let’s enjoy the weekend – workday analysis with DAX

    • Post author:Michiel Rozema
    • Post published:November 16, 2020
    • Post category:DAX/Power BI
    • Post comments:1 Comment

    In this post, I show an approach to non-standard time intelligence analysis. This is, in fact, the second article on AutoExist. In the first, I explained the general principle of…

    Continue Reading Let’s enjoy the weekend – workday analysis with DAX
    What is being calculated anyway? Understanding AutoExist

    What is being calculated anyway? Understanding AutoExist

    • Post author:Michiel Rozema
    • Post published:November 9, 2020
    • Post category:Power BI
    • Post comments:1 Comment

    When working with DAX measures, it is critical to think in terms of context. Those of you who have taken our course of DAX Fundamentals, or attended one of our…

    Continue Reading What is being calculated anyway? Understanding AutoExist
    Introduction to Drill Through in Power BI Reports

    Introduction to Drill Through in Power BI Reports

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

    One of the foundational features of Power BI visual reports is interactivity. The capability to interact with the report allows for primarily visual representation of insights, while at the same…

    Continue Reading Introduction to Drill Through in Power BI Reports

    Row-Level Security and inactive relationships

    • Post author:Michiel Rozema
    • Post published:March 11, 2020
    • Post category:Power BI
    • Post comments:0 Comments

    Inactive relationships in a Power BI model have probably been encountered by everyone who has set their first steps in Power BI. As there can only be one active path…

    Continue Reading Row-Level Security and inactive relationships

    Henk Vlootman, Madzy Stikkelorum, Michiel Rozema

    This blog is about everything we want to share related to the Power Platform.
    • Opens in a new tab

    Recent Posts

    • Determining ISO Week Numbers in Power Query is Super Easy! March 17, 2023
    • Dynamic buttons in Power BI (1) March 13, 2023
    • Linear regression in Power BI: the LINEST/LINESTX functions March 2, 2023
    • ALLSELECTED() and Report Page Tooltips February 16, 2023
    • From Excel to Power BI: using normalized tables (3) January 18, 2021
    • From Excel to Power BI: using normalized tables (2) January 4, 2021
    • From Excel to Power BI: using normalized tables (1) December 15, 2020
    • AutoExist and the Case of the Missing Workdays November 23, 2020
    • Data awareness or data ignorance? November 18, 2020
    • Let’s enjoy the weekend – workday analysis with DAX November 16, 2020
    • Project month in Power Query November 10, 2020
    • What is being calculated anyway? Understanding AutoExist November 9, 2020
    • Introduction to Drill Through in Power BI Reports November 2, 2020
    • Power BI Summer School 2020, sun, fun and … March 11, 2020
    • Row-Level Security and inactive relationships March 11, 2020

    Recent Comments

    • From Excel to Power BI: using normalized tables (3) - Quanto blog site on From Excel to Power BI: using normalized tables (2)
    • From Excel to Power BI: using normalized tables (3) - Quanto blog site on From Excel to Power BI: using normalized tables (1)
    • From Excel to Power BI: using normalized tables (2) – Quanto blog site on From Excel to Power BI: using normalized tables (1)
    • AutoExist and the Case of the Missing Workdays – Quanto blog site on Let’s enjoy the weekend – workday analysis with DAX
    • AutoExist and the Case of the Missing Workdays – Quanto blog site on What is being calculated anyway? Understanding AutoExist
    © Quanto - The Netherlands - www.quanto.eu - info@quanto.eu