From the course: Power BI: Working Together with ChatGPT

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Creating calculated fields

Creating calculated fields

From the course: Power BI: Working Together with ChatGPT

Start my 1-month free trial Buy for my team

Creating calculated fields

“

Starting with the exercise file open for this movie, let's go ahead and open up Power Query by selecting Transform Data. Now, here in Australia, employers have to pay superannuation for permanent members of staff. The current rate is 11% of the annual salary. Say that we want to calculate this amount for each staff member in a simple and effective way. In Power Query, this is called a custom column, and the process to create the calculation is relatively straightforward once you know how. But let's see what advice we can get from ChatGPT. With a new chat window open let's ask the question. Using Power Query with Power BI Desktop, how can I create a calculation based on another column? Okay. This looks really, really promising. We need to scroll back up to see the instructions that are relevant for us, and we can actually jump ahead all the way here to step four, which is creating a new column. And you'll then see that we've got…

Contents