Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.