Need Help based calculate based on column

[erhan_79]

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" 

 

[erhan_79 · Accepted solution]

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?

[az38]

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?

[erhan_79 · Accepted solution]

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?

[az38 · Accepted solution]

@erhan_79 

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" )​

[erhan_79]

@az38 

spasibo aleks 🙂