Using Custom Column instead of Conditional Column in Power Query

preview_player
Показать описание
Demonstrating a middle way between the Power Query and M code.

As an alternative solution to MrExcel's video at:
  1. Suat M. Ozgur
  2. power query
  3. m code
  4. excel
Рекомендации по теме
Using Custom Column 0:01:55

Using Custom Column instead of Conditional Column in Power Query

Four SMART Ways 0:16:12

Four SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1

Incorporating M In 0:25:11

Incorporating M In Custom Column - Problem Of The Week #9 (Power Query Solution)

Define Data Type 0:04:51

Define Data Type in the Custom Column step in Power Query

How to add 0:04:06

How to add IF formula in Power Query in custom column. How to custom column in Power Query

How to add 0:06:33

How to add a custom column in Power BI Query Editor

30 - Adding 0:05:28

30 - Adding a Custom Column in Power Query in Excel

Measures vs. calculated 0:06:00

Measures vs. calculated columns in DAX and Power BI

How to create 0:06:07

How to create Custom column + conditional +index column in Power BI

Try Power Query 0:12:02

Try Power Query Instead of Excel for Data Cleaning

Power Query: Easily 0:11:40

Power Query: Easily Add Custom Columns Using 'Column from Examples'

Inserting text manually 0:04:46

Inserting text manually in a custom column and should be visible on refresh of the report

Difference between CUSTOM 0:10:24

Difference between CUSTOM Column vs. CONDITIONAL Column | Power BI

Power Query - 0:01:00

Power Query - Go to Specific Column A Cool Trick! - Part 16 #shorts #powerquery #powerbi

Get the First 0:08:06

Get the First Column instead of the Last Column in Excel VBA

Promote a row 0:19:32

Promote a row to a column - Part 2: Power Query Challenge

How to Change 0:00:18

How to Change Excel Column Name

Stop using Text 0:00:43

Stop using Text to Column

YOOtheme Pro 2.1 0:10:00

YOOtheme Pro 2.1 - Dynamic Conditions and Custom Column Layouts

Power Query: best 0:15:37

Power Query: best of OR function converting custom to conditional column

Create an Elementor 0:06:40

Create an Elementor Posts Loop with Custom Column Link

4 Ways of 0:05:07

4 Ways of Getting Column from one table to another in Power BI

Power BI - 0:04:04

Power BI - Custom Sorting in 3 Easy Steps!

Custom Column, Conditional 1:17:15

Custom Column, Conditional Column, Column from Examples , & Custom Function in Power BI

Комментарии
Автор

Hey Suat,
(Nice to hear your voice.)
Here are some suggestions:
• we don’t need the ChangeType step, so I would have removed that, too.
• I would just write the oneliner directly in the formula bar.
• After you’ve done that you notice that you actually get a gear icon behind the step — I suggest you point that out next time.
• Investigating that gear icon: we see that it’s a beautiful Filter Rows interface: brilliant!
How to get that interface:
• On any column click the Filter Button (that’s a hint ;-)
• Choose the (…) Filters option,
• Choose any sub-option…
Et voilà!
Further hint: choose Advanced and do what you have to do.
This is the PQ Interface that Mr. Excel was looking for, BTW. :-)
Cheers!

GeertDelmulle