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 VI
Super User VI

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 VI
Super User VI

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 VI
Super User VI

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
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

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!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors