Power BI Support
Search
Lookup within a range of columns
Hello, I have the following problem: my table "Data" is Category 1 2 3 4 5 6 7&n...
Re: How do I share a report so non-PowerBI users can use it?
Thanks Dond, I don't have those options, so will get on to my IT dept. Here's what I can see in the 'Admin Portal'... Once I've 'published to web', will non-PowerBI users be abl...
Re: Gráfico de columnas apiladas: muestra solo valores filtrados como columna
Gracias por la respuesta. ¿Cambiaste alguna configuración?
Get latest date from one column based on a value from another column.
Hello, I need some help to get the latest date from one column based on a value from another column. let's say I have a table like this: ID_NAME NAME DATE_1 (day.month.year) ...
Días consecutivos desde que se perdió el objetivo
Hola a todos Como dice el título, ¿cómo cuento los días consecutivos desde que se superó por última vez un valor objetivo? Tengo un recuento de días por debajo del objetivo y días terminados,...
Extracción de pares clave/valor de json
Hola Comunidad, Estoy leyendo algunos datos de una tabla en Big Query y una de las columnas es una columna anidada que se extrae en PQ en formato JSON como este: {"v":[{"v":{"f":[{"v":"MA...
Re: Deneb - How to add measures on another dataset
Hey @AlexandreCoutoB. Look into performing a fold transform on your original dataset to get them into key-value pairs. This will be more aligned to the table format you're looking for. If th...
Re: Counting working days in DAX months
You can use the NETWORKDAYS function. https://dax.guide/networkdays/
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 ...