Modify a SQL request, write a form in Power Query
If in column 2 the sign "0", then the sum in column 4 should be plus.
If in the column 2 the sign "1", then the sum in the column 4 below is with minus... if there is already a minus, then minus to minus gives a plus...
Option 1 is possible in Power Query to write the formula, and to replace already in the uploaded data that you need, I just create the necessary column with the formula, then I will remove the unnecessary to me. I need a formula...
Option solution 2, you may be able to do this at the time of downloading from the SQL base, i.e. with a request... Here’s how the request looks at the moment:
The Task 2. You need to modify the request so that you do not download the RecordKind column, but at the time of the download to formate the column 4.
Client's review of cooperation with Dmitry Vasiliev
Modify a SQL request, write a form in Power QueryAll super, Dmitry excellent knows his business... Knowed in Power BI and with databases... I recommend.
Freelancer's review of cooperation with Taras Melnichuk
Modify a SQL request, write a form in Power QueryThank you for cooperation!
All questions were resolved very quickly.
A great customer, I recommend everyone to work with Taras.
-
Hello to you. Ready to perform in the best way. Great experience with such tasks. turn to
A systematic approach focused on your P&L and Cash Flow. I'd be glad to dive into your project details in private messages! -
298 5 0 Good day .
I think it is better to modify the request.
You can use the case or cross application.
with respect,
Dmitry
-
3988 231 7 3 Ready to help with this task.
I have great experience working with databases.
I will be glad to help you.
Current freelance projects in the category Databases & SQL
Dashboard on Dune AnalyticsStyle reference: dune.com/filarm/polymarket-activity Task To create a neat, visually appealing dashboard on Dune for our bot for Polymarket. At this stage, demonstration (synthetic) data is used — it is generated programmatically but looks logical and plausible, in the style… Databases & SQL ∙ 1 hour 9 minutes back ∙ 1 proposal |
Power BI
16 USD
The dashboard runs on a Google server, we need to transfer all logic + code Required skills: deployment of ETL processes on a Linux server + working with BigQuery and Postgre There is working code that runs on Google, where the database itself is, we need to transfer it to… Python, Databases & SQL ∙ 19 hours 35 minutes back ∙ 13 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 2 days 19 hours back ∙ 11 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 3 days 6 hours back ∙ 5 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 6 days 13 hours back ∙ 16 proposals |