Skip to content

Blog
Videos
Contact
About

Blog
Videos
Contact
About

Add Column

Page Image - Define Data Type While Creating Custom Column

Define Data Type While Creating Custom Column in Power Query

15th October 2021 by Rick de Groot Categories Power Query

In this post you learn how to define a Data Type at the same moment as you add a custom column. By default, Power Query …

Categories Power Query

Stay in the Loop

Get the latest Excel and BI advice, tips and in-depth tutorials delivered straight to your inbox.

Leave this field empty if you're human:

Subscribe to my Channel

Want Some Help

As well as being a blogger, I’m an independent consultant with a passion for Excel and Power BI. I have background in Finance and work with customers to find business solutions that increase insight and quicken decision making. I’d be happy to work on interim assignments.

For more details see:

Recent Posts

List.Generate in Power Query: Tutorial with Easy Examples
How to use List.Generate to make API Calls in Power Query M
Lists in Power Query M / List Functions (200+ Examples)
Create Date Table or Calendar in Power Query M | including Script
Get Value from Previous Row using Power Query

Tags

Add Column Array Break-line Calendar Carriage Return Column Type Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Custom Column Data Model Data Type Date Date.From DateTime.LocalNow Error Message Formatting Function Group By List List.Dates List.Distinct List.Generate List.Numbers List.ReplaceMatchingItems List.Sum Modulo New Instance Pivot Pivot Table Power Pivot Rank replace ROUND Split Column SUMIF SUMPRODUCT SUMX Table Table.ColumnNames Table.Max Text.Combine Text.From Ties XLSB

Categories

DAX
Excel
Power BI
Power Query

About BI Gorilla®

BI Gorilla is a free resource site for Excel and Power BI enthusiasts. BI Gorilla was founded in 2018 by Rick de Groot. The main goal of this site is to provide quality tips, tricks, hacks, and other resources that help you advance with Power BI and Excel.

RECENT POSTS

List.Generate in Power Query: Tutorial with Easy Examples
How to use List.Generate to make API Calls in Power Query M
Lists in Power Query M / List Functions (200+ Examples)
Create Date Table or Calendar in Power Query M | including Script
Get Value from Previous Row using Power Query

TOPICS

Add Column Array Break-line Calendar Carriage Return Column Type Comparer.OrdinalIgnoreCase Conditional Formatting conditional if-statement Custom Column Data Model Data Type Date Date.From DateTime.LocalNow Error Message Formatting Function Group By List List.Dates List.Distinct List.Generate List.Numbers List.ReplaceMatchingItems List.Sum Modulo New Instance Pivot Pivot Table Power Pivot Rank replace ROUND Split Column SUMIF SUMPRODUCT SUMX Table Table.ColumnNames Table.Max Text.Combine Text.From Ties XLSB

SOCIAL

YouTube
Twitter
LinkedIn
Facebook

Search for:

© 2021 Gorilla BI