cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
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" 

 

Capture-33.JPG

 Capture-34.JPG

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Post Patron
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?

 

View solution in original post

Highlighted
Super User II
Super User II

Re: Need Help based calculate based on column

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

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

View solution in original post

4 REPLIES 4
Highlighted
Super User II
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
LinkedIn

Highlighted
Post Patron
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?

 

View solution in original post

Highlighted
Super User II
Super User II

Re: Need Help based calculate based on column

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

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

View solution in original post

Highlighted
Post Patron
Post Patron

Re: Need Help based calculate based on column

@az38 

 

spasibo aleks 🙂

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

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

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

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors