
Power BI project
- or -
Post a project like this460
€129(approx. $151)
- Posted:
- Proposals: 5
- Remote
- #4270546
- OPPORTUNITY
- Awarded
Description
Experience Level: Entry
Hi!
I like you to create a fresh Power BI project. Outcome = 1 query with the mockup data as in powerbi query output.xlsx.
The project should load the ACTUALS excel file, and for every sheet:
- iterate per column as from column C, and per column: iterate through the cells and do the below for the rows where C column has a decimal value and is not equal to 0
- feed column A in every row with the value in worksheet cell A2
- feed column B in every row with the iteration's column where value is Actual or Forecast or Target
- feed column C in every row with the iteration's column where A column = "For the Quarters Ending"
- feed column D in every row with the value in column A,
- feed column E in every row with the value in the iteration column
In "powerbi query output.xlsx" I gave an example for only the output for the C columns for all (2) worksheets
I like you to create a fresh Power BI project. Outcome = 1 query with the mockup data as in powerbi query output.xlsx.
The project should load the ACTUALS excel file, and for every sheet:
- iterate per column as from column C, and per column: iterate through the cells and do the below for the rows where C column has a decimal value and is not equal to 0
- feed column A in every row with the value in worksheet cell A2
- feed column B in every row with the iteration's column where value is Actual or Forecast or Target
- feed column C in every row with the iteration's column where A column = "For the Quarters Ending"
- feed column D in every row with the value in column A,
- feed column E in every row with the value in the iteration column
In "powerbi query output.xlsx" I gave an example for only the output for the C columns for all (2) worksheets
Rene S.
100% (30)Projects Completed
21
Freelancers worked with
20
Projects awarded
66%
Last project
17 Nov 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies