Power BI Support
Search
Count
Hello, I have created a simple table where measure Count_Lost2 = if ( [Last_Sales] == BLANK (), 1 ) I want to count this coulmn. Is it not possible...
Re: Web.Headers using MS Graph to handle (expected) HTTP-errors seems not possible. Any suggestions?
Unfortunately that does not solve the problem, as ManualStatusHandling is not working from Power Query. So the query halts completely, before I am able to handle the error. Still hop...
Re: Group Total on Specific Row
The ISINSCOPE function is not available in my Power Pivot installation...
Re: Count the amount of times a value appears in a column
thank you very much for the solution 🙂
Re: Combining Files Error in Power Query
@wynhopkins thanks for your clarification Do you perhapse have a link to monitor this process? I would like to keep updated.
Modelo CDM inválido
Eu estou tentando criar um fluxo de dados no DataVerse, conectando uma base do Excel online e aparece o seguinte erro: " Não foi possível converter o mashup em um Modelo de CDM válido. Corrija...
Count a column that has a ID that is a combination of text and numbers.
Hi all, How to count a column that has a ID that is a combination of text and numbers. For example: Table has IDs by month. I want to be able to count the distinct IDs by month and ...
Re: Data Type True/False not displaying in Matrix table
@v-yuezhe-msft How is this marked as Delivered while the answer is not related to the question? Question is on matrix and answer is on tables? I am dealing with same issue and can't find a mea...
Cargar datos grandes de Cosmos DB en Power BI
Tengo un conjunto de datos de alrededor de 300 millones y datos crecientes en Azure Cosmos DB. Cuando cargo los datos, dejan de cargarse debido a problemas de conexión después de cargar unos pocos mi...
Isinscope
Hola comunidad, Tengo una tabla PROJET relacionada con una tabla CONTRAT que está relacionada con mi mesa TRANCHE. 1 Proyecto = muchos Contrato = 1 Contrato = Muchos Tramo cuando ut...
Re: Count
Ohhh, nice! Thanks so much. It works 🤗
Re: Días consecutivos desde que se perdió el objetivo
¿Puede compartir una captura de pantalla de la tabla de datos (eliminando cualquier información confidencial)?
Re: Refresh API data of published report fails due to credentials
Hi. Please make sure you know the development and you are sure it is anonymous because you are getting the token inside. Sometimes people think it's anonymous because it works on desktop on the local...
Re: Share report to user but that user can also share the report to another user
Hi there. Usually when you share content to a user there is a check box to preventa that. You can read more about sharing here: https://learn.microsoft.com/en-us/power-bi/collaborate-share/servi...
Difficulty with Data Labels on graphs
Hi, I have a line graph with slicers to switch between different functions. Since the $ amounts vary significantly between the functions, I have to set the y-axis and data labels to display ...
Re: Using both ALL and ALLEXCEPT together?
@tamerj1 / @ValtteriN Slight variance on the above. In the Data above, lets say I have an extra coloumn called [TIMETOPRODUCE] but I want that to filter out orders less then 155 ...
Weighted Average Scores with Categories
Hi I am looking for help trying to create a weighted score based on the column days and the 2 categories Technician and Category, source data table is in this format: Technician ...
Circular dependency
HI, I am getting circular dependecy error. these two columns are calculated columns in a calclated table created from measures
Re: Differense between 2 dates and time
I tried it but it only counts the hours between shiftstart and shiftto on one line. I want to know the hours between date 1 and date 2. If there is less then 11 hours between ShiftTo date 1 a...
Re: Uso del gráfico de barras para mostrar los totales en la parte superior y el desglose debajo
En ella @v-cgao-msft , La idea es crear solo el visual que mostré arriba, no la matriz. Los valores en la matriz se mostraron solo para resaltar que el objeto visual a continuación debe mostrar núm...
Summarization inside appended table
Hi guys, I have 2 tables: 1. Available Hours across Teams/Roles for Week1 – Week3 Team Role Week1 Week2 Week3 Red A 40 40 40 Red B 40 40 40 Red C 40 40 40 Blue A 4...
Re: How to find the column according to the minimum value and the position
@tamerj1 Sir how to modify the calculated column to get the shared image result. = VAR CurrentValue = 'Table'[tho_cw_diff] VAR CurrentIDTable = CALCULATETABLE ( 'Table', ALLEX...
¿Ocultar algunas filas de subcategorías y mantener otras?
Hola Tengo un problema para el que no puedo encontrar una solución. Tengo una matriz de datos en la que tengo categorías. Para una de estas categorías tengo 2 niveles de subcategorías, para las otr...
¿Cómo ordeno el desglose en el gráfico de cascada en PBI en función de los meses y no de los valores?
He agregado Start y End Bar usando condiciones de interruptor y las averías son dinámicas (no se pueden arreglar en la instrucción Switch). Quiero que los desgloses se ordenen en función del orden de...
Re: Hello All, I need help on how to use DAX expression in Power BI Desktop
@tamerj1 That makes sense but why does it only let me access the tables when I use 'MAX' function? Also, you gave me a formula for if the row had multiple values then use = CONCATENATEX ( '...