Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Delta Values, within subgroup (skip in between subgroups)

Hi,

 

I have a calculation for delta-values for subgroups that is fine within each group - however whenever there is a new subgroup the calculation is not able to differentiate,

 

How would I manange the calculation to handle the in between subgroups as well?

Where the calculation sasys 9.936.002 I would like to have zero - since the next line is a new subgroup (column "MeterTagID"),

 

 

 

Data_P16 = 
var _nextvalue=
CALCULATE(SUM('DataLog_P16'[Data]),FILTER('DataLog_P16',[Indeks]=EARLIER('DataLog_P16'[Indeks.1])))
var _data=
_nextvalue-[Data]
return IF(_nextvalue=BLANK(),BLANK(),_data)

 

 

 

Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    Anonymous You need to add meter tag matching: 

     

    Data_P16 = 
var _nextvalue=
CALCULATE(SUM('DataLog_P16'[Data]),FILTER('DataLog_P16', [MeterTagID] = EARLIER('DataLog_P16'[MeterTagID]) && [Indeks]=EARLIER('DataLog_P16'[Indeks.1])))
var _data=
_nextvalue-[Data]
return IF(_nextvalue=BLANK(),BLANK(),_data)

2 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    5 years ago

    Anonymous You need to add meter tag matching: 

     

    Data_P16 = 
var _nextvalue=
CALCULATE(SUM('DataLog_P16'[Data]),FILTER('DataLog_P16', [MeterTagID] = EARLIER('DataLog_P16'[MeterTagID]) && [Indeks]=EARLIER('DataLog_P16'[Indeks.1])))
var _data=
_nextvalue-[Data]
return IF(_nextvalue=BLANK(),BLANK(),_data)
  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Try like

     

    Data_P16 = 
var _nextvalue=
CALCULATE(SUMX(FILTER('DataLog_P16',[Indeks]=EARLIER('DataLog_P16'[Indeks.1] && [MeterTagID]=EARLIER('DataLog_P16'[MeterTagID]), 'DataLog_P16'[Data])))
var _data=
_nextvalue-[Data]
return IF(_nextvalue=BLANK(),BLANK(),_data)