Forum Discussion
Streaming database - sum value by latest date and key
Hello, thanks for all the involvement.
It was more than weird that it wasn't working, so I did some research and it came out that this is a product bug.
That's a pity because we need to move to different solution.
Here someone reported it:
And here is my idea for fixing it, that you may upvote:
Regards,
Rafal
v-xicai , hey so actually that formula doesn't throw a syntax but it shows blank values anyway :(
Those live datastreams are so annoying :smileymad:
Hi Anonymous ,
For the column formula, I have made some changes, please try to use the latest formula.
Value_Sum =
var d=LASTNONBLANK('Table'[Date],1)
return
CALCULATE(SUM('Table'[Value]),FILTER(ALLSELECTED('Table'),'Table'[Key]=EARLIER('Table'[Key])&&'Table'[Date]=d))
Result:
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
New columns are disabled in streaming databse unfortunately..