Determine top 1 per category - Help filling in the missing parts for multiple criteria

[kfschaefer]

I came across the following and I need assistance in determining the best approach.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Top-1-per-category/m-p/225700#M49

which is the best to determine the top description per PackageType per month/Year.

Example from the approve funciton is similiar to what I trying to accomplish

Something like this.

Sample data.

https://www.dropbox.com/home/SamplesBI?preview=kfsSampleData1.xlsx

Invoice date format as mmmyyyyy - no hard code date 

Return results 

PackageTypeName	Description	InvoiceDate	Qty
Each	Green Shirt….	201301	306
Bag	White Chocolate ….	201301	25
Packet	Pack of 12 action figures (variety)	201301	20
Pair		201301	0
Each	Green Shirt….	201305	52
Bag	White Chocolate ….	201305	25
Packet	Pack of 12 action figures (variety)	201305	1
Pair	Mixed Color Shirt	201305	2
Each	Green Shirt….Mediim	201309	35
Bag	White Chocolate ….	201309	4
Packet	Pack of 12 action figures (variety)	201309	3
Pair	Purple XL Shirt, Mens	201309	25
Each	Green Shirt….	201401	25
Bag	White Chocolate ….	201401	1
Packet	Pack of 12 action figures (variety)	201401	2
Pair	Mixed Color Shirt	201401	35
Each	Green Shirt….	201501	99
Bag	White Chocolate ….	201501	100
Packet	Pack of 12 action figures (variety)	201501	14
Pair	Mixed Color Shirt	201501	25

[v-yuta-msft]

Hi kfschaefer,

Say "The sample BI doesn't exist", could you share the sample data again and clarify more details?

Regards,

Jimmy Tao

[kfschaefer]

Data File Try this out

https://www.dropbox.com/s/sxu2if509e8k3wd/kfsSampleData1.xlsx?dl=0