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
Use the following DAX expression to check whether a table column in your Power BI data model contains a specific string: For example: Search for multiple strings: For example: Check that text exists in a Power BI column Importing your Data Set For this example, we will use a simple list of courses that we … Read more
To cast a Power BI column from integer or decimal format to string texts use the following DAX code: Import dataset to Power BI I will first go ahead and import a sample office list from an Excel file managed by the Real Estate folks. Here is the data set that we have acquired into … Read more
Here’s a question from Kevin: I have a date time column in one of my Power BI data model table representing a timestamp. I would like to create a few additional columns to the table each of those will increment the first column by 08:30 hours, which is our default shift duration. Any ideas on … Read more
Melvin asks: I have a date column in my Power BI model. Can you explain how to create both month name and month number to the Power BI report i need to prepare for the next management meeting? Creating month columns in Power BI Define a date column In case you still don’t have a … Read more
Here’s a question from our reader, Martina: I have a table that contains date values. For reporting purposes, i would like to transform those dates into a custom text string which includes the date, month and year, which i would like to use when creating tables and charts in my report. Any ideas are appreciated … Read more