Here’s a question from Judy: I have a large data set for which i create a calculated column that contains the division of two Power BI columns and shows up as a percentage . When i use the calculated column in a dashboard, the percentages gets aggregated as a sum. Instead of calculating row by … Read more
Here’s a question from Jason: I have a dataset containing sales orders info. I need to group data from different columns to generate a small dashboard. I understand that i am able to aggregate, then calculate the sum and average values per group using the Transform tab or using code. Can you provide a simple … Read more
Step 1: Identify your date fields This fictitious company has a target to finalize the candidate interviewing process in less than 7 (seven) business days. To analyze the situation we will calculate the time between first interview and the signing of the employment agreement. Use the Model or Date Views in Power BI to locate … Read more
Step 1: Import your Data to Power BI If you haven’t acquired your dataset, make sure to import it into Power BI. In our case we will import an Excel spreadsheet containing the following columns. All entries in the Year column are of type text (strings). Step 2: Transform text to Dates with Power Query … Read more
Step 1: Identify the column to multiply In this example, we would like to show how we multiply two columns from different tables in our model. Our goal is to create a column showing the Net Sales Amount for specific Orders. Here’s a preview of our model: To make the required calculation, we will multiply … Read more
Step # 1: Define your measures and columns In this example, we will work with a subset of our Course Registration data model. Our goal will be to calculate the Profit for each Business Intelligence course we are currently delivering. Here is our model: We will focus on two columns in our model: Step # … Read more
Here’s a question from Alice: I am working on a dashboard which includes a stacked bar chart. Need to add a constant line that runs horizontally starting the ;eft hand side of the y axis and is based on a measure in the data model. Any ideas on how to proceed? Step 1: Create your … Read more
Here’s a question from Louis: A key user asked me to help create a report to dynamically filter contents of a Power BI table between two specific dates. Should be a no-brainer but for some reason i am having a difficult time here. Any ideas? Step 1: Prepare your Power BI data Note: As Time … Read more
Here’s a question from Harry: I have a table with sales data. I would like to create a Power Bi report that will show the count of all specific weeks in which the order intake exceeded a specific amount. Any ideas on how to proceed here. Power BI rows counting with DAX and visuals – … Read more
Use the readxl package to import contents of an Excel file from your file into a DataFrame Make sure to install the readxl library (or the tidyverse library) into RStudio or other R development environment before calling it from your script. Import Excel files into RStudio – Practical Example Step 1: Import the readxl library … Read more