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
Here’s a question from our reader Melissa: Quick question here: i am using the MONTH DAX function in Power BI to calculate the month number from a date. I can also convert a date to a month name with the DAX FORMAT function; or when loading the data in Power Quey with M. Now my … Read more
Vanessa asks: Just getting started with Power BI and trying to make a simple analysis of sales using a table and a visual. My sales data granularity is by day. Any ideas how to summarize it into a weekly and monthly view. Group by month and week in Power BI visual Aggregate by week and … Read more