Did it happen to you that you have calculated a cumulative total (such as running total, or year to date, etc) either using the quick measures or by writing the DAX expression yourself, and then realizing that the calculation happens even for the periods without any real data? For example, you want to stop that Read more about Stop DAX Cumulative Total Calculation in Power BI[…]
Despite my many articles about the importance of star-schema and design principals of fact and dimension tables. I still get this question a lot: “When is good to combine tables vs loading them in the Power BI and creating a relationship between them?” This article is going to answer this question. Relationships In Power BI Read more about Combine Tables or Create Relationships? The Power BI Modeling Best Practice[…]
If you even need to show your DAX measures in a chart without a dimension to slice and dice it, you won’t get a great experience in the visual. In this blog post, I’ll share a trick that you can use to have a nice visualization like what you see in the above screenshot. How Read more about DAX Measure in the Axis of the Power BI Report[…]
I often get this question: “Is it better that I create this calculation as a snapshot table in Power Query (or T-SQL, or the data source), or write DAX measures for it?” If you ever had a scenario of creating a report of snapshots, you know what I mean. “Should I have a table for Read more about Power BI Modeling Tip: Snapshot Table, or DAX Measures?[…]
I have previously explained how to generate a row-number using Power Query. That method is good for pre-calculating row-numbers in the table. However, sometimes, you want to calculate the row number in a visual, based on something dynamic. That is where DAX comes handy. Let’s see how this is possible. Sample model I have a Read more about Generating Row Number in Power BI Visualization Using DAX[…]
I often get this question after I explain about the star-schema. The question is that both my dimensions are filtering my fact table values, but how can I get one dimension filtering another dimension? for example, how can I get only the list of products that have been purchased by this customer? In this article, Read more about One Dimension Filters Another Dimension in Power BI[…]
The trick I am about to explain in this article is used in many samples, and it is not a new trick. However, it is very useful, and many Power BI users are still not aware of it. Let’s say you have to columns: Cost, and Sales, and in one chart, you want to show Read more about Change the Column or Measure Value in a Power BI Visual by Selection of the Slicer: Parameter Table Pattern[…]
I have previously written a method explaining different ways of getting the local timezone. However, that method was only for a scenario with users all in one timezone. What if your users are in different time zones? what if you want to show them information in the local timezone for each user? In this article, Read more about Showing Current Time and Latest Refresh Time at Local Timezones in the Power BI Report[…]
Power BI is a tool that you can get started working with it in a few hours, but to use it in its full potential, these days, you require to have many skills. The variety of solutions and BI implementations is also dictating to have different roles, positions, jobs in the Power BI development market. Read more about Power BI Is Too Much for One Person: Roles in the Power BI Development[…]
I have written a blog article about the date dimension, and also one about the time dimension. However, I got some questions in the comments about how they will be used together in a data model. In this article, I’ll explain that. Date Dimension The date dimension or calendar dimension is one of the most Read more about How to Use Time and Date Dimensions in a Power BI Model[…]