I need to replicate excel's sumproduct function using the DAX language in Power BI. I have attached a simple excel spreadsheet with two tabs of input data as well as the output tab I need to recreate using Power BI instead of excel. In this example, each portfolio has a % allocation to multiple strategies and each strategy has a % allocation to multiple holdings. I need to get the holdings...
excel formula expert needed for drop down menu and graph plotting BUDGET IS ONLY 15, DO NOT BID HIGHER
...divided and sorted to look like data in sheet 2. We should be able to use this formula over and over for different data but in the same form. Formula should be able to handle about 1000 rows of raw data in sheet1 As we enter new data (about 1000 rows) in sheet1 in same form formula/script should automatically process it into sheet 2. This is NOT AN EXCEL
We are a small company with a genius product that has the potential to make millions. We hired marketers and spent $30,000 with zero results. We are now looking for marketers that can, and will, sell our product for a percentage of the profits. Our product is designed by doctors, but we are not [url removed, login to view] are the only company in the world that produces this innovative pain relief...
I need 2 excel spreadsheets created both should have 2000 rows. Two columns in each spreadsheet to be created with a formula to generate date and times. Contact me for more details.
I need to be able to run the levenshtein distance algorithm (or trigram formula if that's better) comparing two sets of data from within a single excel. I believe this is doable via VBA and have included a link to a site that provides the VBA code. [url removed, login to view] The inputs would each consist
I have spent the best part of two to three hours trying to resolve this specific issue. which relates to a formula adding up a series of cells in about 12 sheets. I don't need to use the + for each cell as the numbers are spread across several cells on different sheets. Most of the similar formulas are OK but the VALUE error I corrected became a REF
...someone to tell me what the formula is for the 2 sliders on the homepage of this website; basikloans(dot)com It calculates a monthly loan repayment based on the information input through the 2 sliders. Note: If the loan is below £9k the APR changes to 5.2%, then to 4.5% if above £9k I need someone to write the formula out so I can give it to
...Sheet Van Wingerden [url removed, login to view] Create a formula in the google sheet "Inventory" for each column named (week #). The formula will move inventory from one column to the next based on the time (Sunday evening at 12:00AM PST.) It will also look up the week# according
I need some assistance with building a t-ra-di-ng model in excel. The workflow is pretty basic I am just coming short on about 5 key columns - can describe verbally what I want for each column -- I just can't figure out the correct formulas. I have attached the excel sheet of what I have done so far and a descriptive word document. Stating what I would like done in each column - the columns ...
I have an excel spreedsheet with formula's that I require setting up on Zoho. I need to be able to answer the individual fields and the formulas still work out the sums. These questions / additional fields need to be completed for every lead.
Subtotal Formula to avoid time consuming manual subtotals. I have been trying to use a SUMIF function based on my research but have been unable to figure it out so far.
Wants to design an excel sheet formula and report the outputs on powerpoint, I have the powerpoint report sample that needs to be developed as well, the report is about keeping an eye on a property development progress, which includes the following: 1. Development Update a. Permits Update b. Infrastructure works updates c. Saudi Electric Company
Need a text extract formula for excel. The formula needs to locate one of the following phrases (the first time it occurs) in a cell: LLC Limited Liability Company Limited Ltd Ltd. Company Corporation Incorporation Corp. Inc. Corp Inc Co. Co Partnership Limited Partnership PC Professional Company and then return that phrase along