Temporal Scale Using Calculated Columns In Power BI

Temporal Scale Using Calculated Columns In Power BI - Enterprise DNA

Every so often we’ll be needing the availability of a custom visual of a bar chart or line chart that gives an option to plot the chart either weekly, monthly, quarterly, or yearly. In this tutorial, I’m going to demonstrate how you can create a dynamic temporal scale, using calculated columns that can let you change

Continue reading

Python List And For Loop In Power BI

Python List And For Loops In Power BI - Enterprise DNA

In this tutorial, I’ll demonstrate how For Loop can iterate over Python list elements in Power BI. Take note that a list is a Python data type that consists of elements ranging from the simple to advanced. The For loop enables us to repeat codes that are similar for a limited number of times. It

Continue reading

DAX Query Example Using Various Keywords & Functions

Dax Query Example Using Various Keywords & Functions - Enterprise DNA

In this tutorial, you’ll learn about various keywords and functions in DAX Studio with a specific query example for each one. Specifically, you’ll learn about the ORDER BY and START AT keywords, along with the TOPNSKIP and ADDMISSINGITEMS functions. DAX Query Example: ORDER BY Keyword The ORDER BY keyword allows you to sort a dataset.

Continue reading

Dashboard Layout Design Techniques

Dashboard Layout Design Techniques - Enterprise DNA

Today, we are starting a series on the practical steps that we can do to improve report design, report transparency, and the end user experience. For the first part of this series on developing report transparency, I will be focusing on basic but effective techniques on dashboard layout design that can be easily implemented in

Continue reading