PromptBase
Upgrade
Close icon
General
Home
Marketplace
Create
Hire
Login
Chat
Sell
Explore

Prompt Details

Model
Chat - GPT-3.5 (gpt-3.5-turbo)
Token size
76 ($0.00020 / call)
Example input
Can you please support me with the steps above mentioned?
Example output
Hello! I can definitely help you with that. To unpivot the table, follow these steps: 1. Select the entire table including the headers. 2. Go to the "Transform Data" tab in the ribbon and click on "Unpivot Columns". 3. A new column will be created with the header "Attribute" and another column with the header "Value". Rename the "Attribute" column to "Month/Year" and the "Value" column to "Hours". 4. Click on "Close & Load" to load the new table into the worksheet. To group by the total number of hours per each employee on the year, you can follow these steps: 1. Right-click on the "Month/Year" column and select "Insert Custom" > "Year". 2. Right-click on the "EID" column and select "Group By". 3. In the "Group By" dialog box, select "Year" and "EID" and then click on "OK". 4. A new table will be created with the total number of hours for each employee in each year. To delete all the hours that are below 50 for a single month using M code, you can use the following code: let Source = <Your data source>, #"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {"EID"}, "Month/Year", "Hours"), #"Changed Type" = Table.TransformColumnTypes(#"Unpivoted Columns",{{"Month/Year", type date}, {"Hours", type number}}), #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Hours] >= 50 or Date.Month([Month/Year]) <> 1)) in #"Filtered Rows" Replace <Your data source> with the reference to your original table. This code unpivots the table and filters out all the rows with hours below 50 for January. If you want to change the month, replace Date.Month([Month/Year]) <> 1 with Date.Month([Month/Year]) <> <Month number> where <Month number> is the number of the month you want to filter.
🤖 GPT

Power Query Steps Supporter

Add to Cart
Instant accessInstant access
Usage rightsCommercial use
Money-back guaranteeMoney‑back
By purchasing this prompt, you agree to our terms of service
GPT-3.5-TURBO
Tested icon
Guide icon
Free credits icon
Are you tired of losing time thinking on how to structure your power query steps? With this prompt just execute the things you want to achieve and GPT will do the work for you!
...more
Added over 1 month ago
Report
Browse Marketplace