Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
6 years ago
Solved

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" 

 

 

 

 

Need Help
  • erhan_79's avatar
    erhan_79
    6 years ago

    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's avatar
    az38
    6 years ago

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

4 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    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's avatar
      erhan_79
      Post Prodigy
      6 years ago

      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's avatar
        az38
        Community Champion
        6 years ago

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