need help

hi everyone I need to look for the same part name according to the order date between the order date and + 3 days more spare for exaple: the first line on the order table with part name A-123...

Need Help

Show and Tell

Tips and Tricks

davidibi4524

Frequent Visitor

5 years ago

i can't sum this measure..

what i can do?

Greg_Deckler

Community Champion

5 years ago

davidibi4524 Well, measure aggregation is a slightly different topic. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.

Forum Discussion

need help