How Chat GPT can help to write Complex Excel Function, VBA code and DAX for Power BI

Table of Contents

Introduction

Have you ever tried to write a complex Excel function, VBA code, or DAX using natural language? It can be challenging and time-consuming. If this is your situation, then Chat GPT may be the right tool for you.

Chat GPT is a tool to help non-programmers or non-DAX or Excel users to write Excel functions, VBA Code, and DAX using natural language

You can use Chat GPT to write complex Excel functions, VBA code, and DAX for Power BI.

What is Chat GPT?

It’s a web-based tool that allows non-programmers to write the code without knowing how to program. Chat GPT is an AI-based model developed by OpenAI. It can generate text like a human based on input prompts. It has been trained on a large dataset.

It doesn’t require any special knowledge or skill set from your side as it will automatically generate the code for you when you write down what you want it to do!

How to start work on the Chat GPT?

Go to the below URL and log in with your Google or Microsoft Account. You can Sign up with your other email id also.

https://chat.openai.com/

Few Examples of Chat GPT-

Once you have logged in, you can ask your question. For example, here we asked to create an Excel formula to get the first name from a complete name.

We copied the formula and pasted it on the Excel sheet. It is returning the perfect result.

In the next example, we asked it to write the VBA code to copy the data first sheet to the second sheet with the Supervisor filter given on the select sheet.

We copied the code and pasted it into a new module inside the visual basic editor and assign that macro on a button.

In the next example, we asked to write a DAX function to get the Y-o-Y Revenue. It returns the correct result.

Note: In a few cases it was returning the incorrect code or answer also. So, we suggest don’t believe blindly on this. First, read the code or formula carefully and test it properly before putting it in your live report or dashboard.

Conclusion

Chat GPT is a tool to help non-programmers or non-DAX or Excel experts to write Excel functions, VBA Code, and DAX using natural language. In a few cases, it was returning the incorrect code or answer also. So, we suggest don’t believe blindly on this. First, read the code or formula carefully and test it properly before putting it in your live report or dashboard.