Salvatore CagliariinTowards Data ScienceCalculating the previous value in Power BICalculating the consumption based on meter data looks easy. However, complex situations can be challenging. Let’s see how we can solve…Apr 191
Kyle GibsonHow to Write functions in Power QueryI struggled to learn M LanguageNov 1, 2022Nov 1, 2022
Sebastian Castro ReyesEnsuring Data Quality with Power QueryIn this article, we will explore how to manage the quality of our data in Power Query and how this tool can assist us.5d ago5d ago
Salvatore CagliariinTowards Data ScienceVisualize a business process through data serializationSometimes, we want to visualize a business process in Power BI. This is not easy, depending on the visualization needed.Mar 15Mar 15
Salvatore CagliariinTowards Data ScienceCalculating the previous value in Power BICalculating the consumption based on meter data looks easy. However, complex situations can be challenging. Let’s see how we can solve…Apr 191
Sebastian Castro ReyesEnsuring Data Quality with Power QueryIn this article, we will explore how to manage the quality of our data in Power Query and how this tool can assist us.5d ago
Salvatore CagliariinTowards Data ScienceVisualize a business process through data serializationSometimes, we want to visualize a business process in Power BI. This is not easy, depending on the visualization needed.Mar 15
Kyle GibsonHandling Multiple Excel Files and Multiple Sheets in Power QueryMultiple Excel files with multiple sheets and unknown amount of columns? No problem!Mar 9, 2023
Sebastian Castro ReyesImprove Your Data Quality with Power QueryIn this article, we will perform data cleaning for a database, where we encounter different issues when receiving a database. We will use…Jul 9
Salvatore CagliariinTowards Data ScienceCalculate the percentage of the total with RLS in place in Power BIWith RLS in place, some users can see only some aspects of the data set. But what happens when they must compare the result to the total?Feb 5