cancel
Showing results for
Did you mean:
Highlighted Post Patron

## Need Help based calculate based on column

Hi there  ;

i need to calculate 2 measures as below based on sales groups

Measure A will calculate based on first date of and based on Sales Group "58A"

Measure B will calculate based on last  date of and based on Sales Group "58C"  2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted Post Patron

## Re: Need Help based calculate based on column

hi @az38

For measure A i need to calculate only  first dates of table , for measure be i need to calculate only last dates of table , you need to revise something?

Highlighted Super User II

## Re: Need Help based calculate based on column

no problem

try

``````Measure A=
var _minDate = CALCULATE(MIN(Table[Date]), ALL(Table), Table[Sales Group]="58A")
RETURN
CALCULATE(SUM(Table[Amount]), ALL(Table), Table[Date]=_minDate, Table[Sales Group]="58A" )``````

and

``````Measure B =
var _maxDate = CALCULATE(MAX(Table[Date]), ALL(Table), Table[Sales Group]="58C")
RETURN
CALCULATE(SUM(Table[Amount]), ALL(Table), Table[Date]=_maxDate, Table[Sales Group]="58C" )​``````

do not hesitate to give a kudo to useful posts and mark solutions as solution

4 REPLIES 4
Highlighted Super User II

## Re: Need Help based calculate based on column

Hi again @erhan_79

try

``````Measure A=
var _minDate = CALCULATE(MIN(Table[Date]), ALL(Table), Table[Sales Group]="58A")
RETURN
CALCULATE(SUM(Table[Amount]), ALL(Table), Table[Date]=_minDate, Table[Sales Group]="58A" )``````

and

``````Measure B =
var _minDate = CALCULATE(MIN(Table[Date]), ALL(Table), Table[Sales Group]="58C")
RETURN
CALCULATE(SUM(Table[Amount]), ALL(Table), Table[Date]=_minDate, Table[Sales Group]="58C" )​``````

but for Measure B you highlited last, not first day. what exactly do you need?

do not hesitate to give a kudo to useful posts and mark solutions as solution

Highlighted Post Patron

## Re: Need Help based calculate based on column

hi @az38

For measure A i need to calculate only  first dates of table , for measure be i need to calculate only last dates of table , you need to revise something?

Highlighted Super User II

## Re: Need Help based calculate based on column

no problem

try

``````Measure A=
var _minDate = CALCULATE(MIN(Table[Date]), ALL(Table), Table[Sales Group]="58A")
RETURN
CALCULATE(SUM(Table[Amount]), ALL(Table), Table[Date]=_minDate, Table[Sales Group]="58A" )``````

and

``````Measure B =
var _maxDate = CALCULATE(MAX(Table[Date]), ALL(Table), Table[Sales Group]="58C")
RETURN
CALCULATE(SUM(Table[Amount]), ALL(Table), Table[Date]=_maxDate, Table[Sales Group]="58C" )​``````

do not hesitate to give a kudo to useful posts and mark solutions as solution

Highlighted Post Patron

## Re: Need Help based calculate based on column

spasibo aleks 🙂

Announcements #### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge! #### Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers! #### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members. #### Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community. Top Solution Authors
Top Kudoed Authors
Users online (1,137)