Gili 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
Here’s a question from Dorothy: I am using Google Sheets and trying to use a Pivot table to group my data according to the week number. For some reason, that is not possible, although i see many other useful grouping options such as day of the week, day of the month, year-month etc’/ Any hints … Read more
Here’s a question from Emilio: I loaded an Excel spreadsheet to my Power BI desktop app, and inserted a stacked chart visual. When looking at the x axis i see that the chart month axes (X) is sorted our in a wrong order – in my case alphabetically – which doesn’t make much sense. How … Read more
Here’s a question from Ulrich: I work as a project manager in a remote company out of South East Asia. Part of my job is to share files with my co-workers via channel conversations and 1:1 chats. Thing is that from time to time, file uploads get stuck for some reason. Not sure whether it’s … Read more
In this short tutorial we will learn how you can use Visual Basic for Applications (VBA) to automate the saving of your Excel 365 spreadsheet. Our code will assign a custom file name, consisting of a prefix concatenated with the current date and time. Macro to save workbook with VBA Step #1: Prepare your Excel … Read more