In this post, I will show you some Power BI tips and techniques on finding the previous value that accounts for weekends and holidays. This came up in a post by Brian Julius in the Enterprise DNA forum. The developer of this report wanted to calculate the percentage difference. However, the developer didn’t want to
In today’s blog post, I want to show a segmentation technique inside Power BI. I also want to discuss the considerations that you need when using it across your entire Power BI report. This is a way of bringing additional insights to your data that you may not have been able to do so in
I want to introduce you to a group of functions in Power BI called table functions. These functions include FILTER and ALL which we already used or mentioned in other topics. There is a whole range of other table functions which includes functions like VALUES, TOPN, and ADDCOLUMNS. However, we are not going to cover
In this blog post, I’ll introduce you to DAX table functions. Table functions are simply DAX functions that return a table. Some of the most common table functions that you can encounter in Power BI are the FILTER, VALUES, and ALL functions. Using these table functions, you can create virtual tables inside Power BI. Physical
In this tutorial, I’m going to teach you how to manage multiple date calculations in your Fact Table in Power BI. This is a frequent question in the Enterprise DNA Support Forum. These multiple dates could be order dates, ship dates, expiration dates, and arrival dates, among many others. This information might be located within
