One of the most exciting skills to learn in BI tools like Power BI or Tableau is how to create dynamic measures. The idea is that since dashboard space is limited, using dynamic controls—such as allowing users to select which measure to display—keeps the dashboard both compact and powerful for users. In this post, let’s … Continue reading How to create dynamic measures in Excel with Python in Excel