Forum Discussion
sunah132
Helper I
Helper IRank and Partition
I have a list of items with pricing as value by delivery date. Because the direct query data has multiple duplicated entries per items, the row subtotal shows 10X more than what it should be. If I cr...
sunah132Helper I
Helper IThank you, I have attached a new example about this.
ryan_mayu
Super User
Super Useryou can try this
Measure 2 =
var TBL=SUMMARIZE('Sheet1',Sheet1[Date],Sheet1[Item],Sheet1[Item code],"min",min(Sheet1[Item Cost]))
RETURN SUMX(TBL,[min])please see the attachment below
- sunah132
Thank you!! It applied as I was expected!
If there's a miscellaneous cost on every Wednesday per item code, may I add like this?
var TBL=SUMMARIZE('Sheet1',Sheet1[Date],Sheet1[Item],Sheet1[Item code],"min",min(Sheet1[Item Cost],(sheet1[Misc cost])) RETURN SUMX(TBL,[min])- sunah132
Yes, Sorry. Here is the dropbox link below.