Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Folks,
I am working on a req to create Rolling 90 Days sum from a table which have multiple occurances for same date.my req is I want to get sum of first all the values for every date first(example Sum of all values on the second column for feb 1 in below snip and similarly for every other date also.) I have a measure for this :
Issue: I got the sum of values for each day from the measure I mentioned above but now I am trying to work on another measure which shoud get me the sum of last 90 days for every date.
Thanks in advance
Solved! Go to Solution.
Hi @PBIROO ,
I have created a simple sample, please refer to my pbix file to see if it helps you.
Create measures.
Measure = var _90=MAX('Table'[date])+90
var _minindex=MINX(FILTER(ALL('Table'),'Table'[date]=SELECTEDVALUE('Table'[date])),'Table'[Index])
return
IF(_minindex=SELECTEDVALUE('Table'[Index]),1,0)
Measure2 =
var _90days=MAX('Table 2'[Date])+90
return
SUMX(FILTER(ALL('Table'),'Table'[date]<=_90days&&'Table'[date]>=SELECTEDVALUE('Table 2'[Date])&&[Measure]<>0),'Table'[value])
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Share data in a format that can be pasted in an MS Excel file and show the expected result very clearly.
Hi @PBIROO ,
I have created a simple sample, please refer to my pbix file to see if it helps you.
Create measures.
Measure = var _90=MAX('Table'[date])+90
var _minindex=MINX(FILTER(ALL('Table'),'Table'[date]=SELECTEDVALUE('Table'[date])),'Table'[Index])
return
IF(_minindex=SELECTEDVALUE('Table'[Index]),1,0)
Measure2 =
var _90days=MAX('Table 2'[Date])+90
return
SUMX(FILTER(ALL('Table'),'Table'[date]<=_90days&&'Table'[date]>=SELECTEDVALUE('Table 2'[Date])&&[Measure]<>0),'Table'[value])
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
123 | |
111 | |
99 | |
60 | |
60 |
User | Count |
---|---|
138 | |
116 | |
102 | |
70 | |
57 |