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 [đăng nhập để xem 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: [đăng nhập để xem URL] this is created by this shortcode: [mychart name="files/Dax30/[đăng nhập để xem 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: [đăng nhập để xem 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...