Tag: DAX

Power BI Tips And Tricks For Your Reports

Power BI Tips And Tricks For Your Reports - Enterprise DNA

To avoid falling into the trap of creating ineffective reports, I would like to share with you a selected number of Power BI tips and tricks that will definitely help when building your Power BI report. There are three main reasons for ineffective reports: the lack of context, trying to communicate too much, and inability

Continue reading

Enhance Your Report With The Laws Of UX

Enhance Your Report With The Laws Of UX - Enterprise DNA

When aiming to create astonishing reports, following the laws of UX is a must. The laws of UX are the most important principles you need to know and consciously implement inside your Power BI report because they will guide the design of your report and story. For this tutorial, let’s focus on the laws of

Continue reading

UNION DAX Function Vs Power Query

UNION DAX Function Vs Power Query - Enterprise DNA

In this tutorial, you’ll learn a DAX optimization technique using the UNION function. This tutorial will compare the performance of the UNION function versus Power Query and other techniques for combining tables. The UNION function combines two tables into a single table by combining their rows and removing any duplicate rows. The example in this

Continue reading

Power BI Split Column By Delimiters In DAX

Power BI Split Column By Delimiters In DAX- Enterprise DNA

In today’s blog, you will learn how to use Power BI to split column by delimiters using DAX. This is something you would probably know how to do easily using Power Query, and that is generally the best way to do it.  But because of the dynamic nature of the problem and the specific considerations

Continue reading

Power BI Page Navigation Buttons

Power BI Page Navigation Buttons - Enterprise DNA

The Power BI page navigation buttons play a critical role when it comes to storytelling. An organized and transparent navigation system acts as a roadmap to direct visitors to various pages inside your report. These buttons are fundamental in encouraging visitors to stay, engage with your content, and have a positive user experience that would

Continue reading