I have written dozens of articles about row-level security so far and explained in all of them explained different methods in which you can reduce the amount of data rows that a user can see based on their roles. However, in my presentations, I still get this question that: What if I want to compare Read more about Calculating Total, and Percentages in a Row-Level Security Power BI Model[…]
I have explained previously how you can use the Table.Profile Power Query function to fetch the profiling data of a table, such as minimum value, maximum value, null count etc, and use it in a report page to inform the user about the quality of the data. However, that function doesn’t provide you with one Read more about Get The Error Count with the Profiling Data of Power BI Data Table using Power Query[…]
LookupValue function is neither a new function in DAX nor a complex one. However, I figured out in my training courses and presentations, that there are still a few people aware of this function. This is a very simple, yet powerful function in DAX which is particularly helpful whenever you are looking to find a Read more about Find The Data Value using LookupValue DAX Function in Power BI; Simple and Useful[…]
For the world of Power Apps users, the Common Data Services (CDS) might be more understandable, however, in the world of Power BI users, we still have many who don’t know what it is and what is the use cases of it. So I thought better to write about it in this article, and explain Read more about What is Common Data Service (CDS) and why it is important for you if you use Power Apps or Power BI?[…]
There are always many questions about a cheat sheet to shows the existing capability for doing AI and ML in Power BI service and Desktop. In the above chart, I have summarized the capability of doing AI and ML in Power Service and Desktop for each role. I have identified three main roles in Read more about Overview of Available AI and ML capabilities in Power BI[…]
If you are at Microsoft Ignite 2019 in Orlando, I have five streams of Power BI for you to watch; three sessions, and two podcasts. All on Power BI subject. If you are attending Ignite in person, I am more than happy to see you there. Otherwise, you can watch these sessions via live streaming. Read more about Learning About Power BI at Microsoft Ignite 2019 North America: Reza’s Sessions[…]
In the previous article, I have explained what is the key influencers visual and how it works. Later the count and impact have been explained in the other Post. Initially, Key Influencers visual just has two data fields: Analyze and Explained by the Analyze fields, analyse the data based on row by row, so Read more about Key Influences Visual: Expand By Fields[…]
If you ever need to create a list of numbers (either decimal or whole number), or list of dates and times, there is a very simple and useful function in DAX which helps. GenerateSeries is a simple function to use to create a list. In this article, I’ll explain how you can use this function. Read more about Creating a List of Numbers or Dates in Power BI using GenerateSeries Function in DAX[…]
In Power Query, there is an easy way to use Duration and get the number of days, hours, minutes and seconds from it. However, sometimes you need this calculation to be dynamic as a measure in DAX. I had that requirement too. And I wrote a simple DAX calculation which will give you the result. Read more about Calculate Duration in Days Hours Minutes and Seconds Dynamically in Power BI using DAX[…]
In another blog article, I explained how easy is to use table constructor in DAX to create a data table fast in Power BI. However, that method has some limitations, such as not being able to name columns or set their data types. In this blog post, I’ll explain about DataTable function in DAX which Read more about Using DataTable DAX Function for Creating Structured Table in Power BI[…]