Closed

Project for Jesus Alejandro G. -- 2

I have a data table which contains values by period. The periods are text fields e.g. 2017 07, 2017 08 etc. The data for a particlular measure is defined by a field called category. I 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.

acting on the table in the example. The resut being a pivot table that looks like the second table in the example. It will need to calculate for each line the total for the last 12 months period. If it helps to add an index column to the original table which starts at 1 for the first month then this is OK. Will have other DAX issues going forward that i will need help with

Skills: Excel, Microsoft Access, Telecommunications Engineering, Visual Basic for Apps, Web Scraping

See more: Project Description Looking for an experienced software developer who\ s very familiar with C++, Javascript, Emscripten to port , The design concept is simple but elegant daily wear. We need 12 designs of which 4 tops, 4 midi dress, 2 outerwears and 2 long , I need a script written that i can run on a windows PC to rename 30,000 images from its existing name to another. -- 2, we need to 25 persons who talks like this their seriousness looks, House plan for 80ft X 30ft Plot size -- 2 I need some design work. house plan for 80ft 30ft plot according vaastu 80ft side is n, 2 Bugs need to be fixed in a webpage, virtual city project final animation blender 2.71, php 2 version need only one, m 2 buyer need, jesus alejandro, ekushey project manager v1 0.2 wordpress plugin, jesus alejandro video, calculus 2 help, project website pure talent 2, project website - pure talent -- 2, need sales team based commission, need set reservation form uses html, need source web based time attendance, help garments project using asp, help java project chat, cisco project help router isp, excel project help needed, wsdl project help staffingemployee data, help accounting project

About the Employer:
( 8 reviews ) Solihull, United Kingdom

Project ID: #15091085

7 freelancers are bidding on average £17 for this job

aimefx

Hi, I am expert in Excel, Power Pivot, Power BI and DAX formulas. I have check your excel file, please send me the data file I will create create pivot tables based on DAX formulas. Relevant Skills and Experience You More

£20 GBP in 1 day
(5 Reviews)
3.5
rashmiqueen

i can do it Relevant Skills and Experience excel Proposed Milestones £18 GBP - excel

£18 GBP in 1 day
(0 Reviews)
0.0
SMI2011

Hi, I would like to work in this project. I am able to complete this with accuracy and quality. I can meet the deadline. Please consider my proposal and give me a chance to work in this project. Thanks! Murali

£18 GBP in 2 days
(0 Reviews)
0.0
£10 GBP in 1 day
(0 Reviews)
0.0
ITspecialist247

Stay tuned, I'm still working on this proposal.

£19 GBP in 1 day
(0 Reviews)
0.0
shamanazir786

A proposal has not yet been provided

£18 GBP in 3 days
(0 Reviews)
0.0
globalshopindo

Hi my name budi...my skype: budi darma... have team work in Indonesia Freelancer...Me and My Team Expert.... [login to view URL]

£13 GBP in 1 day
(0 Reviews)
0.0