Dax design trabalhos

We have have a java/kotlin program that doesn't have an updated walker on it, we found the source for the updated version but its incompatible with our current syst...fork from. This is the client that has the actual walker we would like ported, we can show 2, one is called daxwalker, the other is unethical walker Unethicals is in this github. Obviously more than just that folder will be required to be ported, or edited in the meteor-client. This is dax walker, you can choose between them both, ideally daxwalker would be of choice, as I have used it in other clients previously that ported it themselves and worked wonderfully.

1. Convert text format : x heures to number or in duration by creating a new measure exemple 2,5 heures become 2,5

We are looking for a kn...relate to training and others will be How to guides, getting started guides, tips and hints etc - We will provide the structure, high level scripts and content outline of the videos. We will also take care of the post production side of it. - What we need from you is the ability to record the videos and provide the narration/training. - For example, there may be a video on "Time Intelligence using DAX". We will provide a structue of what should be included in the video and a high level script. We will also provide the data and pbix model. Your task would be to create the video and provide the necessary training/walk through. - The expect the videos to be between 10 and 20 minutes long initially We are looking for a long term partnership for ...

Looking for a Power BI developer with good DAX knowledge so help complete a data model. I currently have a .pbix file with my data loaded in and the necessary relationships created between the tables. I have a bunch of measures relating specifically to each table that need creating. The data subject is inventory reporting and the measures include metrics relating to order counts, average lead times, parcels, headcount split and so on. I've prepared a document that lists out all the required measures including a description and which fields from which tables they should use. (See attached) The Power BI developer should be able to create the measures and also create simple visuals within the report to display those measures. The presentation of the visuals and style of th...

We have a already built the dataset with all the relationships. We need to convert the sql query to dax formula for an AR ageing report which the user can choose at a specific time

Hello, we are need in expert for training for one month for around 60 hours. It includes teaching required skills for Business and data analysis related to portfolio management. Training is for practical skills . - busine...for Business and data analysis related to portfolio management. Training is for practical skills . - business and data analysis for data analysis technology -data and business requirements covered from A TO Z -technical and functional design -solution design relying on data requirements (improve existing dashboard ) -training for system and data usage -learn nonfunctional and regulatory requirements -agile methtods,solution design and change management -IT business analysis, solution design and technical specification -power bi (etl, ...

DAX help required to create x2 custom measures/Visualization. I have a sort of resource matrix that says which areas are under resourced and which over. Need help creating measure that tells me how much resource is required to bring under resourced area into balance; and a second measure to say where is that additional resource coming from.

Hola, Estoy buscando un consultor en Power Bi para realizar formaciones-consultas en Power Bi, sobre todo en lenguaje DAX (Power Pivot) y lenguaje M (Power Query). Mi idea es pagar un paquete de horas, que pueda utilizar para realizar consultas en remoto para solventar problemas a los que me enfrento a la hora de elaborar modelos de Power Bi. Si estan interesados en el trabajo, si pueden enviarme un presupuesto de un paquete de 10 horas de consultoria. Un saludo

I have created this dashboard on Walmart sample date form super store provided by Kaggle Started by uploading the dataset to power BI, changed the datatypes of some columns, and then created calculated columns & calculated measures using DAX functions. Then moved to create a dashboard using cards, slicers, bar charts, pie charts, line charts, and donut charts to produce meaningful insights from the large dataset.

count x dax function power bi need some help on that

Hello Govind, I need a person to help me build dax measures and sometimes SQL also. It's not gonna be a full time or even a part time job but, at the end, it will be something with no effort. Interested?

Hello Dasari V., I need a person to help me build dax measures and sometimes SQL also. It's not gonna be a full time or even a part time job but, at the end, it will be something with no effort. Interested?

I need an assistant to help me in my PowerBi project and answer my questions (DAX, charts, etc). You need to be willing to work by the hour through zoom meetings.

I am looking for a solid real-life Power BI project description experience to crack my upcoming interview as power bi reporting analyst. I want from you to provide me at least two (2) or three (I prefer three) projects that you have done recently using your power bi skills. All projects description should be in ...(Situation, Task, Action, and Result/outcome) method. I want you to quantify your projects, for example, you can use some numbers in problem/situation statement and then result section as well. It would be great if the project is related with healthcare industry, but it is not mandatory. Each project description should be at least 500 words. Keywords: Reports, dashboards, maps and graphs, advance Dax, row-level-security (RLS), power bi service, direct query, filtering...

...Utilize Power BI to build interactive and visually appealing dashboards, scorecard, and reports. · Transform business requirements into technical publications · Design, map data models to shift raw data into meaningful insights and identify the requirements and develop custom charts accordingly. · Build multi-dimensional data models, Run DAX queries and functions in Power BI · Connecting to various data sources, importing data and transforming data for analysis in Power BI, · Perform detailed analysis on tested and deployed Power BI scripts · Develop strong data documentation about algorithms, parameters, models, define and design new systems · Work closely with Data Engineers to take care of data warehouse developmen...

To see the completion of the task by a check if modified DAX formula works

Need handson training on Power BI . Already know how to create dashboards but need training on advanced topics 1) Need to learn how to use Dax 2) How to use directquery. 3) How to create custom apps and visuals

Looking for a power BI expert for a report formulas fixes.

Good experience in Design and Development of end-to-end BI Solution using Microsoft Power BI Good experience in analyzing Business requirements and convert to technical solution Experience in building Enterprise data model to support static and Ad hoc Self serv reports Good Knowledge on capacity estimation and Power BI Premium capacity configurations Good experience in writing DAX expressions, M Query Language Experience in building Power BI datasets, Data flows and deployment pipelines Experience in Configuring Gateways for different kind of source systems Exposure to custom visuals development for Power BI Experience in Row Level security implementation and user access management Experience in configuring incremental refresh for Power BI datasets Hosting Power BI reports in...

I am looking for a freelancer who is Power BI (Dax Expert). who has expertise in formulas fixing in the Power BI. We need to work on screen share and looking forward to meet ASAP and complete it today.

We need an expert in power BI for 20 hours a week with a good sense of design, very technological and analytical with the ability to develop in measures with DAX

I am looking for a freelancer who is Power BI (Dax Expert). RankX, Filter, Earlier, Calculate formulas expert. We need to work on screen share and looking forward to meet ASAP.

Integration of Xero with Mechanic Desk and T-Sheets to develop a KPI reporting Dashboard with user interface. Requires use of DAX to filter and calculate data as required.

PLEASE READ CAREFULLY: INITIAL ONLINE MEETING REQUIRED FOR UNDERSTANDING OF THE JOB, IF YOU CAN NOT MEET, DO NOT BID!!! I have an on going Power BI job to do and will need an expert for consult and resolving of the tough tasks. Will need to be done live as I will have to share...will need an expert for consult and resolving of the tough tasks. Will need to be done live as I will have to share my screen explain the task and then you will help with the fix The problem is not something I can hand off for the person to fix and send back to me. The person has to be able to fix the issue while I am sharing my screen It is mostly DAX & Power Query manipulation or recreation of an existing DAX & Power Query manipulation A Dax pro will be an added advantage Let chat...

I am data analyst ,and have high experience in data manipulation I am using excel , power pi (Dax and power query, building dashboard and stories),tableau, python tools for analyzing . for the project , i will work on part 1 and part 2 of the project for making data analysis for each dataset will the details written in the Assessment

Have created an excel file with a data model containing actual and budget columns from 2 separated tables. I would like to add a new calculated columns (i guess using DAX formulas) in order to get variance numbers (actual vs budget amount and actual vs budget %.. Need help on the 2 calculated columns. Also any other additions that might be better for such spreadsheet -Data model is already created

I have quite experience with power bi at the level of visualization using available measures but iam not able to creat sales measures for my work I need some one to help with creation of sales measures that enable me to Compare this year sales with last year sales monthly and also to date ( april is the first month of the year for our work ) Creat Moving annual totals for the data I have my sales data reay in 4 columns Column 1 : date Column 2 : sales quantity for this specific date ( many rows as day may have many sales for different customers) Column 3 : Customer name Column 4 : Customer location The work will need the freelance to contact me on zoom or any tool as the data can’t be sent and i have to work on my machine so he will need to guide me how to write or manage t...

Hello, I'd like to get some help on a specific problem. I'm working on some financial data and need to create measures that hide all the visuals in the report if some conditions don't meet. I have a simplified table with some columns. More detailed explanation is attracted in the file

Por favor, Cadastre-se ou Faça Login para ver os detalhes.

Hi Anas D.! I'm struggling with some dax issues and I wanted to know if you are available for some troubleshooting, thanks in advance, it is not very complex

Write DAX formula in Power Bi to count the rows and display repeat order and not repeat order customers by text see example as attached excel file

Hi Anas D., I am working in power bi and a lot of what I am trying to do requires DAX which i don't know much about. I can send you excel documents that I want to replicate but more insightful in power bi. I can also send you the excel spreadsheets with all of the data. From there i would like the monthly updates to be as automated as possible.

I am looking for a helpdesk ticketing dashboard. I am struggling with some DAX. I also need to display percentage increase and decrease of tickets over period of times, etc. I can provide screen recording and files to right freelancer. The goal is to have a PROFESSIONAL dashboard with date Filters, etc. You also need to show me how you did it. Write POWER BI at the starting of your proposal.

Hi Ravi, I am looking for a helpdesk ticketing dashboard. I am struggling with some DAX (diffilcult to explain all trough this message). I also need to display percentage increase and decrease of tickets over period of times, etc. The goal is to have a PROFESSIONAL dashboard with date Filters, etc. 2nd "project" would also be for you to show me how you did it. Project should start THIS WEEK. I can send you the current file that I have if i have an email address so you can estimate the time.

I am in need of some help with Microsoft PowerBi & DAX. I have data which includes Month to Date sales and Monthly Targets. I am trying to identify the best way to calculate End of Month Projected Sales & End of Month Projected Attainment. Example: It is the 18th of October and I currently have 50 Actual Items sold Month To Date. My Target/Goal for the month is to sell 85 Items. Based on these numbers, I am projected to sell 86.1 items in the Month of October with an attainment of 101.3%. For projected Sales (Calculation: (50 Items/18 Days) * 31 Days = 86.1), For Projected Attainment (Calculation: 86.1 Projected Sales /85 Target Sales = 1.013 or 101.3%). While I could use real numbers, they are obviously variable and I would need to to change when the data changes ea...

...Utilize Power BI to build interactive and visually appealing dashboards, scorecard, and reports. · Transform business requirements into technical publications · Design, map data models to shift raw data into meaningful insights and identify the requirements and develop custom charts accordingly. · Build multi-dimensional data models, Run DAX queries and functions in Power BI · Connecting to various data sources, importing data and transforming data for analysis in Power BI, · Perform detailed analysis on tested and deployed Power BI scripts · Develop strong data documentation about algorithms, parameters, models, define and design new systems · Work closely with Data Engineers to take care of data warehouse developmen...

I am looking for a DAX expert who can help me in the complex requirement in a report. He should be well versed with conditinal columns and dax optimization as well.

We have multiple projects on Power Platforms. DAX & API integration experience would also be great.

Create Power bi reports from ETL mssql with DAX query .

...Generación de prototipos y presentación. Recogida y documentación de requisitos. Elaboración de cuadros de mando en Power BI ¿QUÉ REQUISITOS NECESITAS?: Amplia experiencia en visualización utilizando Power BI Experiencia en el desarrollo de soluciones ETL utilizando SSIS y/o Data Factory Buenos conocimientos técnicos en SQL Server o Azure Synapse. Experiencia en la escritura y optimización de consultas DAX. Buen nivel SQL Recogida de requisitos funcionales. Buenas habilidades de comunicación y comprensión Buena comprensión de Data Warehousing. Experiencia en interacciones con clientes y análisis de requerimientos ¿DESEABLE?: Certificación Azure Data Engineer. Conocimientos...

Hi, I have got stuck on a Powerpivot task, and need someone to let me know the correct formula. I just want to sum the rows below a subtotal. At the moment it keepts recalculating dynamically. Each row is calculating the mix which is margin - price impact - volume. The issue is that volume is calculated dynamically so a new average unit cost is calculated...calculated dynamically so a new average unit cost is calculated for all profuct groups when I use the "All" function, where as I just want to add the numbers/rows underneath, using the average unit cost at those levels. So simply I want to add the rows below without it recalculating and working out a new average when I use the ALL function, I have tried Sumx but to do success. I believe for a dax expert this is an ea...

I need to take my PBI that I have done so far to the next level on visualizations and more advanced DAX formulas and Measures. All data has been loaded and cleaned in PQ and DIM and FACT tables are in place. The model needs reviewing, new time intelligence measures, sharp graphics, and innovative ideas.

Por favor, Cadastre-se ou Faça Login para ver os detalhes.

I'm new to DAX and looking to write a very simple query to calculate Distinctcount of ids if a condition is met. In the attached excel, there are two columns Orders and Inflammable. Each order can have multiple rows (based on SKUs) and Inflammable is Y/N field to tell whether SKU is inflammable. My ask is to find the number of distinct orders where there are more than two inflammable SKUs. Please see the attached excel file to know more about it. A skilled person may not even take 5 min to write/correct the measure.

I am stuck in a DAX formula, calculating the Annual same quantity for the years 2019-2020-2021. However I did try to solve it using the following formula but was not able to do it. Annual Sale Quantity = CALCULATE( sum('Past Orders'[Order Quantity]), FILTER('Past Orders', 'Past Orders'[SKU ID]=Stock[SKU ID] && 'Past Orders'[Order Date]>=today()-365))

Hi, As discussed , I am sending you the quotation for the project of Project Management Data Analytics. Find the details of project deliverables below. I am planning to provide the following services. 1.[$10.75] Add Slicer and average percentage for overall project 2.[$7.25] Explanation on Modeling 3.[$3.25] Explanation on DAX 4.[$3.75] Explanation on dashboard As a professional data analyst, I am offering this competitive price without sacrificing quality. If you have any questions after reviewing this proposal, feel free to touch base. Regards, Araf

I need an experienced Powerbi developer who can understand the existing DAX formula and change the formula as per requirement. File cant be shared but anydesk / zoom / teams access can be given.

I have a simple Excel table having 5 columns, ~10rows. A "Line and Stacked Column Chart" Visual will be prepared. Important part is, I have two user groups. "Managers" and "Public". Column "A": x axis Co...say Columns "C" and "D" are sources. "Managers" group will see all, "Public" group will not see "Line" from column "D". Both the line and its legend will not be seen by "Public" users. Whichever user group is chosen, the visual will not show error state, instead will visualize other 4 columns nicely. This is valid for both Desktop and published reports. You can use RLS, maybe OLS and / or any DAX code. I have Power BI Service subscription and the job will be tested by...

Un Dashboard que contenga la base de datos de redes sociales de una marca que además se puedan calcular diferentes columnas para obtener un puntaje. Se posee la base de datos completa y la formula en excel, se debe traspasar este trabajo a Power Bi. dominio de DAX avanzado.

I want to combine the average results of week 8/1, 8/8 and 8/15 to get my assumptions for week 9/5 using DAX in PowerBI I'm using past results to calculate assumptions two weeks ahead. That means I need to combine results of week 8/15, 8/22 and 8/29 to get my estimates for week 9/19 If my skill doesn't have data, the estimate will be 30%