Forum Discussion

sunah132's avatar
sunah132
Helper I
5 years ago

Rank 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...
Need Help
sunah132's avatar
sunah132
Helper I
5 years ago

Hello,

As the table below, I tried to see if I can add the MIN of Misc charge add up with the item cost if they were on the same delivery date. Thank you very much!

 

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

sunah132 

you can try this

Measure =
var TBL=SUMMARIZE('Sheet1',Sheet1[Date],Sheet1[Item],Sheet1[Item code],"min",min(Sheet1[Item Cost])+min(Sheet1[Misc Cost]))
RETURN SUMX(TBL,[min])