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 VI

## 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 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

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 VI

## 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 #### 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?

We're excited to announce our first cross-community 'Can You Solve These?' challenge! #### 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

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5. Top Solution Authors
Top Kudoed Authors
Users online (1,495)