2022-06-30

How to do a SUMX on a GroupBy table in Webi?

I have a DAX code in PowerBI that displays how many "check-ups" have been done in a particular location. I am currently trying to transfer this over to SAP Web Intelligence Rich Client.

1.2_FrequenciedDay- = 
var minDate=MIN(Datekey[ModifiedDate])
var maxDate=MAX(Datekey[ModifiedDate])

var summarizedTable=SUMMARIZE('x','x'[Datekey],"count",distinctcount('x'[DivisionKey]))
var Cumulativesum=SUMX(FILTER(summarizedTable,[Datekey]>=minDate&&[Datekey]<=maxDate),[count])
return Cumulativesum

Is there a SUMX and SUMMARIZE translations for Web Intelligence?



No comments:

Post a Comment