Project for Jesus Alejandro G. -- 2

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

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

Excel Microsoft Access Telecommunications Engineering Visual Basic for Apps Web Scraping

Project ID: #15091085

About the project

6 proposals Remote project Active 6 years ago

6 freelancers are bidding on average £17 for this job

ITspecialist247

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

£19 GBP in 1 day
(1 Review)
0.8
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
shamanazir786

A proposal has not yet been provided

£18 GBP in 3 days
(0 Reviews)
0.0