Tag: Power Query Date Table

DateTime Value: How To Strip Off Seconds

DateTime Value How To Strip Off Seconds - Enterprise DNA

In today’s blog, we will examine three ways to strip off seconds from a DateTime value. You can watch the full video of this tutorial at the bottom of this blog. If at all possible, you’ll want to lower the cardinality of your data while still meeting business requirements. However, DateTime values can have an extremely

Continue reading

Adding Data In Power BI | A Power Query Tutorial

As we know, data has a lot of different forms before we can retrieve and bring it in Power BI. Power Query offers several advantages when it comes to importing and consolidating Power BI data. In this blog, we’ll discuss the different ways on how we can bring data in Power BI. Think of Power

Continue reading

DAX And Power Query | Creating Self-Sorting Columns

Subsequent to a recent DAX pop quiz that I prepared and posted on LinkedIn, one of the people who responded to the quiz raised a fascinating idea, via which text columns no longer needed a numeric sort column to put them in proper order. I experimented with this new approach and it worked beautifully. In

Continue reading

Power Query M: Alternating 0-1 Pattern In Date Table

Power-Query-M-Alternating-0-1-Pattern-In-Date-Table

This tutorial focuses on using the Power Query M number.mod function to create an alternating 0-1 pattern in the Date table. The solution that I’m going to show you came from one of our community power users, Rajesh, at Enterprise DNA. You may watch the full video of this tutorial at the bottom of this blog.

Continue reading

Sorting Date Table Columns In Power BI

Sorting Date Table Columns In Power BI

In today’s blog, I’ll discuss a question that comes up all the time in the Enterprise DNA forum. How can you can sort the fields from an extended date table columns properly? You may watch the full video of this tutorial at the bottom of this blog. This refers to the extended date table from

Continue reading