Define Data Type in the Custom Column step in Power Query

Показать описание

In this post you learn how to define the Data Type in the same step in which you add a custom column. It saves you an extra step and prevents clutter in your queries.

WRITTEN ARTICLE:

Master Functions and Syntax in M

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUPPORT MY CHANNEL

SUBSCRIBE TO MY CHANNEL

LET'S CONNECT:

Thank you for your support!

#PowerQuery #CustomColumn #BIGorilla

Рекомендации по теме

Комментарии

that's great. i've watched many m code videos and taken many courses and nowhere have i seen that there are two different syntax types that produce the same result. so, this is very helpful to someone wanting to learn m code. keep up the good work in producing videos that are concise and useful. please consider offering a full course on m code or PQ. thank you.

arnoldschwartz

Great playlist, and appreciate the list of types available in the blog. I've been aware that ", type..." could be added to many steps, however after trying it for a while I discovered that if a step was modified and even sometimes the any part of the query was modified, the ", type..." I had added was automatically removed, so I simply stopped doing that. I didn't make any connection with what functions specifically did that, and perhaps when using a Custom Column that won't happen. Have you encountered the disappearing ", type...", and are you sure that wouldn't happen with a custom column?

jerrydellasala

Great tip! But the currency type is missing. Can you only add it with gui?

georgebuisson

Hi I’m facing problems when I’m I connecting from snowflake table in 255 column names ( like date, text, number ) in to power query, there is two steps auto generating 2 steps, source and Navigation, the next “changed type” is not generating .
My question: how to write a custom column to change all columns data type at one time based on their column type .
Yes if I have 10 columns I can change manually. But now I have 255 columns.
Requesting you please help me it will very helpful to me
I’m following your videos it is very helpful.

In advance many thanks

Best Regards
Venkat

venkatnarayanathulava

Are you related to the Gorilla Glue Girl? You should teach her Power BI at least.

Phoenixspin

Define Data Type in the Custom Column step in Power Query

What Are Data Types?

2.1 Data Types & Type Modifiers | Data Structures & Algorithms Course in C++ | Lecture 2.1

Define Data Types as per the First Row in Power Query

Data Types vs. Abstract Data Types

Primitives Data Types In Java - All the Primitives And What They Do

Define Data Type in the Custom Column step in Power Query

C_10 Data Types in C - Part 1 | C Programming Tutorials for Beginners

Can you define different sizes of the data types | A Visual Guide

Data Catalogs Exposed: Implementation Secrets You Need Now

Coding Basics: Variables | Programming for Beginners |

Data Types in Java (Hindi) | What is DataType? full Explanation | Learn Coding

Data Types, Variables & Constants

Types of Data Structures

SQL Data Definition and Data types

C# - DataTypes and Variables | Learn Coding

Introducing MATLAB Fundamental Classes (Data Types)

Data Structure Definition & Advantages

Variables in Java ✘【12 minutes】

Variables and Types of Variables | Statistics Tutorial | MarinStatsLectures

#10 Python Tutorial for Beginners | Data Types in Python

Qualitative and Quantitative

Scales of Measurement - Nominal, Ordinal, Interval, & Ratio Scale Data

Variables & Data Types In C: C Tutorial In Hindi #6

C variables 💰