User Profile
sanchar123
Helper I
Joined 7 years ago
User Widgets
Contributions
DAX for Calculating Mean Time for certain conditions
HI Team, I have a condition where the DateTime stamp is not periodic and Pressure should be in the range of 2000< Pressure < 4000 I have the desired calculations explained in the attached figure. Raw data is with the time stamp and pressure values. I have to calculate the Mean Time between Failures (good data duration) = MTBF Mean TIme to restore Services (bad data duration)= MTTS Can you please let me putting the logic. Thanks in advance.655Views0likes2CommentsRefresh failure in services for SharePoint data
Hi Following is the error: Data source error: Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries. Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net Activity ID: 9df6579a-****-4ed0-a66b-08c77******* Request ID: 5e604617-****-a47b-89f5-1a673******* Time: 2021-09-08 21:26:29Z The desktop refresh does happen without error, although the schedule refresh is not performing at all and sends the error. I have done the same set up for 15 other reports and they work fine (.csv data files from sharepoint folder to Power BI Services). This particular set is giving me errors and I am not able to find any solutions. my workspace is also in premium capacity can anyone of you let me know what needs to try in this case? Thanks in advance.Solved553Views0likes1CommentRe: Running total or Cummulative sum DAX
amitchandak appreciate your quick help. I am caught in the loop, while executing the query. WOndeirng if this cummulative type of calculation decrese the performance when I am refreshing the data at Desktop level. What can be the solution, running in the Power BI Services? dataflows? I766Views0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.