Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
We have managed to set up a streaming dataset that is driven via a Powershell script which pulls data from our SQLServer DB. Everything is working well apart from some really stange behaviour when trying to create measures, does anyone know if there are any known limitations when working in this way?
One measure we have tried is:
CALCULATE ( [Total], FILTER ( ALL ( RealTimeData[timestamp] ), RealTimeData[timestamp] = MAX ( ( RealTimeData[timestamp] ) ) ) )RealTimeData[timestamp] is a datetime field
Solved! Go to Solution.
Hi @itchyeyeballs ,
Based on my test, it is not supported yet currently. You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Found this when having what I think is same issue: https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Simple-cumulative-sum-issue-with-liv...
Can you link your "feature request" aka bugfix (if you made one)?
Hi @itchyeyeballs ,
Based on my test, it is not supported yet currently. You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
@v-frfei-msft , I'm just building a solution where this feature is a must. Added new 'idea post' about this feature/bug.
Regardless, do you have any information whether it will be resolved?
Thanks,
Rafal
Thank you,
Is there any documentation about this available? It seems more like a bug than a missing feature especially as I got no warnings or errors, just erroneous outputs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |