# How many transactions occurred per X amount of dollars per week

### Question

• Hi there,

I have a table with a long list of transactions that occurred during a period. Each of these transactions have a dollar amount associated with it and there could be more than one transaction per day (with a different dollar amount). I've been tasked to determine how many transactions occurred per \$1,000 dollars in a given year.

Can this be achieved utilizing SQL or Power Pivot?

Thanks in advance.

﻿﻿

Thursday, February 27, 2014 2:05 PM

### All replies

• Hi DSeijo,

Is there a chance that you could provide a small set of test data that can be used to work on a solution? If you can represent the characteristics of the data in as few as 10 rows of test data, this would be sufficient. If you could let us know what you'd expect the outcome to be based on this test data, it will help even more and allow the community to verify their solutions before presenting them here.

Regards,

Michael

Please remember to mark a post that answers your question as an answer...If a post doesn't answer your question but you've found it helpful, please remember to vote it as helpful :)

Thursday, February 27, 2014 4:17 PM
• Hi DSeijio,

It's hard to work out the accurate solution based on the information you posted above, but SQL Server PowerPivot data model provide a lot of functions to do Time Intelligence. I would suggest you take a look at the following articles:
Time Intelligence Functions in DAX: http://blogs.msdn.com/b/analysisservices/archive/2010/04/12/time-intelligence-functions-in-dax.aspx
Time Intelligence Video Tutorial on Project Botticelli #dax #powerpivot #ssas: http://sqlblog.com/blogs/marco_russo/archive/2013/09/05/time-intelligence-video-tutorial-on-project-botticelli-dax-powerpivot-ssas.aspx

Regards,

Elvis Long
TechNet Community Support

Monday, March 03, 2014 9:32 AM
• Can't you simply create a measure like the following:

COUNTROWS('Transactions') / SUM('Transactions[Sales Amount]) * 1000

http://darren.gosbell.com - please mark correct answers

Tuesday, March 04, 2014 7:43 PM