Learn Power Query by Linda Foulkes and Warren Sparrow

Author:Linda Foulkes and Warren Sparrow
Language: eng
Format: epub
Publisher: Packt Publishing LTD.
Published: 2020-07-17T00:00:00+00:00

Figure 6.2 – Power Query Editor

Note

The loading of Excel ranges has been covered in Chapter 2, Power Pivot Basics, Inadequacies, and Data Management, if you are not sure how to do this.

In the Power Query Editor, select Conditional Column from the Add Column tab. This will bring up the Add Conditional Column dialog box, which will allow us to add in our custom column, shown as follows:

Figure 6.3 – Completed conditional column

As shown in figure 6.3, when looking at the completed dialog box, you can see how our If statement works. If the Delivery Date does not equal null, Then say it is Completed. If it is null, then say null. Once this has been completed, select OK.

We can see that the new Delivery Status column now has either null or Completed as the two options in this field:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.