Question: I need help with POWER QUERY IN EXCEL. What script could i write if I am trying to make an if statement. I want to

I need help with POWER QUERY IN EXCEL. What script could i write if I am trying to make an if statement. I want to refer to a folder parameter, and if it contains ME then output is month. If you have any suggestions please reach out!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

i am trying to create a new custom column in power query with excel. I want it to refer to the folder parameter, and if it contains "ME" then a new column named Period will have month going down...

Introduction and learning objectives When you were learning about operational analysis earlier in the term, we talked about jobs that require multiple visits to the CPU (or servers) to receive their...

Within your "BA 315 Datasets" folder, create another folder called, "TEDx" Download the following Excel dataset and save it in the "TEDx" folder: TEDx DatasetLinks to an external site. Download the...

******ebook converter DEMO Watermarks******* ******ebook converter DEMO Watermarks******* ******ebook converter DEMO Watermarks******* ******ebook converter DEMO Watermarks******* Also by Marcus...

This week we learned how Excel can help to present and understand data for a company. Throughout Chapter 1 and 2, we see that Excel spreadsheets can be used to present data, total data, and display a...

Before beginning this lab, run the following script in the SQL Server query window. If you have already created a database called hourglass, be sure to drop the database before running these queries....

Criteria Exemplary 6 points Accomplishe d 4.8 points Developing 3.6 points Beginning Minimum Below Standards 2.4 points 1.2 points Formulated, wrote, interpreted, argued, and evaluated...

This text was adapted by The Saylor Foundation under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License without attribution as requested by the work's original creator or licensee. 1...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

Overview: In this problem set you will: Construct a relational database design for a generic housing authority The Database Design Imagine you work for the public housing agency of a city, and you...

Determine the smallest horizontal force P required to lift the 100-kg cylinder. The coefficients of static friction at the contact points A and B are (? s ) A = 0.6 and (? s ) B = 0.2, respectively;...

?A screw will be self-locking, if .Friction angle is more than helix angle .Friction angle is equal to helix angle .% Efficiency of the screw is 100 O .Friction angle is less than helix angle O

y Fatty acids are clasuified as saternted or unsaturanod, depending on their structure. Beth types of finy acibs are biviopically Satarated Uesaturited

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

What is the difference between an HMO and a PPO? Which one do you prefer? Research the Internet to find one HMO and one PPO.

Why is there a physician shortage? What strategies can you suggest for rectifying this employment issue?

What is a hospitalist? Do you think a hospitalist has a significant role in health care? Why or why not?