Here’s a question from David: Is there a Power BI function that allows to create a table showing specific values…
Here’s a question from Thomas: Sometimes, while building a model in Power BI Desktop, i would like to create a…
Here’s a question from Marla: I have imported a table from Excel. When i bring it up in Power BI…
Problem Statement You have imported a dataset from Excel or an SQL database. The dataset has columns containing numeric data…
Here’s a question from a reader: I have a table containing date time information in a mm/dd/yyyy format. When importing…
Here’s a question from a reader: I have a Power BI data model table for which i have created several…
Here’s a question from Judy: I have a large data set for which i create a calculated column that contains…
Step #1 : Import your data Start by importing your dataset in Power BI. In our example we will use…
Here’s a question from Jason: I have a dataset containing sales orders info. I need to group data from different…
Step 1: Identify your date fields This fictitious company has a target to finalize the candidate interviewing process in less…
Step 1: Import your Data to Power BI If you haven’t acquired your dataset, make sure to import it into…
How to calculate the time difference between a date and today?
Step 1: Familiarize yourself with the dataset In this example, we would like to analyze the root cause of a…
How to multiply a column by a constant or variable number in Power BI?
Step 1: Identify the column to multiply In this example, we would like to show how we multiply two columns…
Step # 1: Define your measures and columns In this example, we will work with a subset of our Course…
Here’s a question from Alice: I am working on a dashboard which includes a stacked bar chart. Need to add…
Here’s a question from Louis: A key user asked me to help create a report to dynamically filter a Power…
Here’s a question from Harry: I have a table with sales data. I would like to create a Power Bi…
Here’s a question from our reader Melissa: Quick question here: i am using the MONTH DAX function in Power BI…
Vanessa asks: Just getting started with Power BI and trying to make a simple analysis of sales using a table…
Combine two columns into one in Power BI To join two our columns in your Power BI data model table,…
How to find the number of days between two dates in Power BI?
Calculate number of days between two days in Power BI To find the number of days in between two dates…
Create a year column in Power BI You can add a year variable to your BI data model by following…
Use the following DAX expression to check whether a table column in your Power BI data model contains a specific…
Here’s a question from Eugene: I need to create a chart that displays some business related KPI by month ina…
To cast a Power BI column from integer or decimal format to string texts use the following DAX code: Import…
How to convert an integer number to a date time in Power BI?
Couple of days ago, while working with a simple csv file, i had to cast a column of integers using…
How to add and subtract hours and minutes to a datetime in Power BI?
Here’s a question from Kevin: I have a date time column in one of my Power BI data model table…
Melvin asks: I have a date column in my Power BI model. Can you explain how to create both month…
Here’s a question from our reader, Martina: I have a table that contains date values. For reporting purposes, i would…
Here’s a question from Emilio: I loaded an Excel spreadsheet to my Power BI desktop app, and inserted a stacked…