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 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
When working with RStudio you define a plot (either with R-base or ggplot2), but the chart doesn’t show up in the Plots tab in RStudio. Most probably, you can solve this issue by explicitly printing your plot: Display R plot if not showing up in RStudio Follow the steps below to print your R-base or … Read more
To fix the R no package called ggplot2 error in RStudio or Jupyter, proceed as following: Read on for a more detailed explanation on how to reproduce and fix the error. Reproducing the no package ggplot error In order to reproduce the error, proceed as following: Here is a screenshot take from RStudio on Windows … Read more
Today we will learn how to fix error messages that you could find in your R development tool such as RStudio, Jupyter and others, when trying to invoke the tidyverse library without it being installed. Understanding the error Error in library(tidyverse) : there is no package called ‘tidyverse’ Here’s a screenshot from the RStudio Console … Read more
In this tutorial we will learn how to append the contents of a Python list to a pandas DataFrame. We will start by creating a simple DataFrame and a Python list. You can use both to follow along with this example. Assign a Python list to a DataFrame From my experience, the easiest ways to … Read more