Error on datasource refresh
Has anyone seen this error before? It happens on datasource refresh. And don't specify where the error occurs... Cluster URI: WABI-BRAZIL-SOUTH-B-PRIMARY-redirect.analysis.windows.net ID da atividade: 20080bab-f27a-4079-9d65-decf90567a65 Solicitar ID: 4f8cfe56-0a7f-4d50-851b-d766ddbe604f Hora: 2023-03-27 13:44:44Z
Count and Sum shows wrong results
I need your support for the below issue. I have connected my excel to power BI and generated graphs. While generating the reports I am facing the below issue: 1. Sum Function: I am calculating man-hours spent on each property, In the below chart "Total man-hours by property" based on the filter, it should show the value as 4 but it shows the wrong value as 6. Please refer to the table below, where the correct value is 2+2 = 4 (total hours spent) is shown; but in the chart, it is showing wrongly. When I make a sum the result is showing wrong with more value and I need your support to fix it. 2. Count Value: In the below chart name "Count of property visits", here actually it should show the result as 2, but it shows a wrong result as 3. Can you please advise on how to fix it. I hope I have clarified my query. Looking forward to your support.
error previewing a reply that has a pasted table from Excel
When pasting a table from Excel into a reply, this Community (not this forum) is showing an error: "Sorry, unable to complete the action you requested." I've converted the Excel table into a range, which I'm pasting below. When previewing my reply without any other text or link, the preview initially warns: "Your post has been changed because invalid HTML was found in the message body. The invalid HTML has been removed. Please review the message and submit the message when you are satisfied." When I try to preview again, the Community shows the error and no preview (the action). However, there's no error if NOT previewing. In other words, the pasted table can be posted in a reply. Just wondering though, am I not correctly pasting? Thanks. searchfor OS ABS CURBSIDE ONE STOP OS OS- OSAP OSCA OSCH OSKD OSLL OSLOB OSNR OSOP OSTA OSWA PROVI PROVISIOINAL PROVISIONAL TRANSAverage per row, reseting on each month
Hello! First Post. I have data of my country's position on a ranking list. I need to determine the average of that position for each month separately. Currently im using: Promedio = CALCULATE( AVERAGE(PowerBI[Posición]); FILTER(PowerBI; PowerBI[Fecha].[Month]<=EARLIER(PowerBI[Fecha].[Month]) && PowerBI[Fecha].[Day]<=EARLIER(PowerBI[Fecha].[Day])) ) But the averages are wrongly calculated. I also noticed that on the first day of the month if position is 50 the average shows 55.5 which means its carrying values from the previous months. Please help me fix my formula. Thanks in advance.
