I'm struggling with transformation limitation regarding live datasets.
My dataset is as follow:
What I want to achieve:
By filtering by latest date that is available for each key (they can be different), I want to show aggregation of those values.
What I have:
But when I filter it by 'latest date', values are being aggreggated from whole dataset.
I guess the main issue comes from the fact that is has also time included.
One idea that came to my mind is to aggregate those data and send them to dataset. But i would prefer to achieve this ideal state in power BI.
Above is similar issue, but here is a need of getting sum of those values.
Thank you for your ideas 🙂
Go to Solution.
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:
View solution in original post
Hi @roofi00 ,
You can create measure like DAX below.
Value_Sum = var d=LASTNONBLANK('Table'[Date],1)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for answer @v-xicai ,
I guess because there are disable calculated columns (due to using streaming dataset, only calculated columns enabled) it throws a syntax error.
Do you think there is other option?
The formula above is used in measure instead of calculated column, if you need to create a calculated column , then try codes below.
@v-xicai , hey so actually that formula doesn't throw a syntax but it shows blank values anyway 😞
Those live datastreams are so annoying
For the column formula, I have made some changes, please try to use the latest formula.
New columns are disabled in streaming databse unfortunately..
From your question, my guess is that you are not concerned with the time stamp. Assuming so, i have been able to solve the question. You may download my PBI file from here.
Hope this helps.
Hey @Ashish_Mathur , thanks for the answer.
I'm afraid that live datastreams have some hidden limitations and due to those, it is impossible to work it out this way.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!