...el cual deseo contactar con un profesional para que labore con nosotros. El perfil seria egresado de universidad con las siguientes aptitudes: • Conocimiento intermedio de DAX, Lenguaje M • Conocimiento general de lenguaje R (Opcional) • Conocimiento de programación web, con el objetivo de incrustar reportes Power BI en una página web de manera segura
...in Power BI to work with me the data of my company. The fee will be fixed by each request and payed at the end of the week through paypal. Requests like, how to build this dax formula, how to achieve to this report, or how to organize and improve the data to get better and faster results. My GMT is +0:00 and would like to be available at least 4 hours
...Index constituents) and all major indices USA – all DOW Jones, S&P 500 and NASDAQ stocks and indices UK – FTSE 250 stocks and indices France – CAC stocks and indices Germany – DAX stocks and indices Switzerland – SMI stocks and indices Euroland – Eurostoxx 50 stocks and indices FX pairs – AUD/USD, AUD/NZD, EUR/AUD, EUR/GBP, EUR/JPY, EUR/USD, ...
I have a consolidated table that have to be moved into the power p using Dax. Idea is to avoid vlook up things in the file that is full of them so it really slow.
...critical report currently pulls data from Salesforce, excel sheets, and our data warehouse. It then does a large amount of filtering and data manipulation within Power Query and Dax, then represents the data in ~90 different report pages. We now have all of the SFDC data in our data warehouse. I need someone who can move as much of the data manipulation
Create DAX columns and measures over data models for the purpose of enhancing Power BI visuals Intermediate to advanced understanding of the DAX (Data Analysis expressions) language in Power BI Has familiarity using DAX functions for formatting numbers, dates, or texts & row level security with Power BI At least 1 year hands-on work experience with
I n...by the following: 1. download german stock data (BMW, Bayer, Lufthansa and DAX) as csv for example from quandl 2. use the quantopian fetcher to upload and analyse the csv files: [login to view URL] 3. benmark the BMW data against the DAX in quantopian. 4. write a short documentation of example and the steps
Hi I am looking for someone who can consult/assist me with specific problems writing code in excel, dax and sql. Working would be on several projects with a Norwegian internet company, as we look to deepen our understanding of customer trends, selling departments and more. Problem example: We have a customer table consisting of: Customer_id
I have a few dax formulas to get me attrition by date selected. However, if we didn't hire anyone in that time period the calculation is off. I have a calculation to count new hires, one for terminations, one for the start of the month headcount (before any new hires or terminations) and the average headcount. The average headcount is (start of the
...foreign keys. 4. Perform analysis of data by building a cube in tabular model in SSAS with measures and dimensions using star schema. Process and browse the cube and include some DAX/MDX Queries just to show how we retrieve data from a cube. 5. Now visualise data in any of the reporting tools either SSRS or Crystal reports with some good information being
...findings with suitable graphs. *Use the following stock market indices for this project: Use the following stock markets 1. Dow Jones (USA) 2. S&P 500 (USA) 3. Nasdaq (USA) 4 DAX (Germany) 5. FTSE (UK) 6. HangSeng (Hong Kong) 6. Kopsi ( Korea) 7. CNX NIFTY (India)...
...performance of the DAX for 01.01.2012 - 31.12.2014. (Determine the DAX values over the days of the corresponding months and use the arithmetic mean as a dependent variable.) Have the results output and interpret them. Represent the model and data points in a common coordinate system As a database you can use e.g. use: Historical courses DAX [login to view URL]
I have a excel file and a test Power BI. I need help to create a DAX formula to calculate attrition. The test file has a hire date and a term date. Need to get the start headcount by removing anyone hired during the selected month or quarter or in the future. Remove any terminated employees that were terminated during the month or quarter selected or
I’m currently working on a PBI visualization project, and I’m struggling to get a measure that would give me accurate Year on Year value. I’d need help with that, similarly displaying month-on-month and quarter-on-quarter data values for specific metrics would be helpful I’d like the project to be completed in the next 2 weeks Any q, please let me know Thanks, Charly
...indicators on dax index: 1) Dax index price with Advance - Decline Volume Line technical indicator., both data horizontal parallel for comparison. 2) Dax index price with 52 week average drawdown or percentage of dax stocks with 2% within All time highs, is it possible to bloomberg show this? both data horizontal parallel for comparison. 3)Dax index
I need an excel formula and a separate DAX formula to count a large dataset of patient visits among many other data points. The count needs to be able to count only the patient account numbers that have charged dollar amounts against the account number by service date month of visit . Distinct count will not work. The account number is shown many times
Code a DAX measure for Power BI that can calculate a weighted average of items, aggregate the data, then apply a second weighted average based on subgroups. All data tables already exist.
Hello here you see a graph: [login to view URL] this is created by this shortcode: [mychart name="files/Dax30/[login to view URL]" instance=1 minheight=500 removeprice= true] and created by this plugin: mychart-v2.8 (MyChart & Performance Plugin Stock) this plugin loads the data from the website of developer: [login to view URL]
Use authentication & authorization in Power BI,• Strong in Analysis Services tabular model, DAX • Strong in Power BI desktop and service • Knowledge on ADF V1 & V2 • Knowledge on Power Shell • Good to have ADLS, ADLA.
POWERBI MODEL: a. Understand how to modify data in power Bi using Power Pivot, DAX. b. Manipulate and model data from an Microsoft SQL database into Power Bi c. Tutelage on Server-side scripting languages & frameworks (python)
please create the following marketscanner in ninjascript: All stocks av...those chosen under a certain condition; have reference to a list. this list is for example: AAPL = NASDAQ SIEMENS = DAX KK = S&P500 As soon as the scanner shows the stocks; the corresponding reference title (like NASDAQ, DAX etc) is also shown and can be analysed.
Dear folks, please create the following marketscanner in ninjascript: All s... those chosen under a certain condition; have reference to a list. this list is for example: AAPL = NASDAQ SIEMENS = DAX KK = S&P500 As soon as the scanner shows the stocks; the corresponding reference title (like NASDAQ, DAX etc) is also shown and can be analysed.
I need a measure formula for powerpivot and MS Power BI to calculate the average payment of a specific identifier (Healthcare CPT Code) from multiple rows that is linked to a date of service and account number. Any other payments or other rows associated with that account that are not specifically tied to the "identifier" CPT code should not be included in the calculation. There are two...
Hi, MUST HAVE POWER BI AND DAX EXPERIENCE – FINANCIAL BACKGROUND WOULD BE HIGHLY RECOMMENDED I have started up a new business which involves reporting and analytics for new vehicle franchise dealers. I have one model which is complete that is excel based and works off a trail balance (totals only no transactions). This will be my base for
Necesitamos un experto en elaborar y transformar datos, los datos se han de mapear y limpiar para transformarlos en datos utiles. Tipo de fuentes estructurada, semiestructurada y no estructurada
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
...powerBI model that I need you to work on. You will need to create one Matrix that will have: Monthly/Cumulative/MAT. YTD figures, Month vs Month Percentage. You need to be good at DAX. So it is transforming Excel Report to PowerBI report. The data is already imported into PowerBI. You only need to construct the new measures etc.. The challenging part is that
Hi Jesus Alejandro G., My work colleague David Betts has sent you a message to advise I would like some help with some PowerPivot/DAX problems. I hope you will be able to help? Thanks, Greg
need a logo done with the caption Straigh Outta Dax Tha Barber - pair of scissors above the text with strings coming down connecting the text. "please look at the God Father logo for idea.
I am looking for expert who is really good in advance excel, Microsoft Power BI stack - Power Pivot, DAX, Power View, power query, power Map,VBA Scripts, Macros, OLAP cubes, MDX and Tableau Visualization Tool.
I need a dax expert for helping me solving an issue with a formula (with a pivot table). 10 minutes task, urgent.
...need a DAX formula that calculates the total for last rolling 12 months based on the category - then uses these totals to calculate an incident rate. Need full explanation of how formula works. Expect the solution to be a combination of calculate and filter functions. To be clear the output is a pivot table containing resulst calculated with DAX formulas