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
Combine two columns into one in Power BI To join two our columns in your Power BI data model table, proceed as following: Merging two columns into one – Practical Example In this section we will provide a simple example for concatenating Quarter and Year columns in a table. We later use the merged column … Read more
Calculate number of days between two days in Power BI To find the number of days in between two dates in Power BI use the DAX DATEDIFF function: Find date differences in PowerBI – A Practical Example Calculate time differences excluding Weekends To calculate the number of days between two data times, but exclude weekends … Read more
Create a year column in Power BI You can add a year variable to your BI data model by following this process: Format date / time column as year To format a Power BI date value as a year column use the following process: Extract the year and month values from a date column Here’s … Read more