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