Power BI Support

Search

Exploración de las características únicas de Power BI: una comparación con Tableau

Hola comunidad de Power BI, A medida que hago la transición de Tableau a Power BI, estoy ansioso por explorar las características distintivas que diferencian a Power BI de sus contrapartes, en pa...

Get PowerBi Audience users via REST API?

Hi,   I've got a report showing all applications and users having access to these applications. Some of the applications have multiple audiences with different users assigned.   When qu...

Re: Suma de los valores de la medida durante los próximos 6 meses

Hola Gracias por su respuesta, pero eso no funciona del todo. El problema es que 'Rendimiento' y 'Rendimiento medio' son medidas, por lo que la función MAX no funciona en ellas, por lo que la medida...

Re: DAX expression that ignores specific filter/slicer

Please Try this measure.      SalesCategory= CALCULATE( [YourKPI], FILTER( ALL('f_Sales'[SalesCategory]), 'f_Sales'[SalesCategory] IN {"A", "B"} ) ) &n...

Group bubbles on map chart into only one bubble with one combined value

Hi,   I hope to combine multiple cities into one and also see only one combined bubble with 1 value.  Is that available?   3 bubbles hope to combine   Now I've grouped ...

Agrupe las burbujas en el gráfico del mapa en una sola burbuja con un valor combinado

Hola Espero combinar varias ciudades en una sola y también ver solo una burbuja combinada con 1 valor. ¿Está disponible? 3 burbujas esperan combinarse Ahora los he agrupado, pero si...

Re: Dataset fail to refresh regularly: The XXX column does not exist in the rowset

According to my test, the parquet connector can only read a specific parquet file. But we need it read a specific folder with several parquet partitions and files.

Re: Assigning a value to an ID based on a column with multiple values

This seems to work but only when it can recognise a number, I'm getting some errors as not all the qualifications will have a numbers.   DataFormat.Error: We couldn't convert to Number. Detai...

Re: Descripción de las expresiones DAX en Power BI frente a Tableau: la perspectiva de un desarrollador de Tableau

¡Bienvenido a la comunidad de Fabric, Manoj! Desgloso sus preguntas de la siguiente manera: P1: ¿Qué son las expresiones DAX? DAX es una colección de funciones, operadores y constantes que se pued...

Descripción de las medidas de seguridad en la conexión de Power BI a Microsoft SQL Server

Estimada comunidad de Power BI, Actualmente estoy explorando el proceso de conexión de Power BI a una base de datos de Microsoft SQL Server y me gustaría obtener información sobre las medidas de ...

Re: IF + AND Code

Thanks for your help, DATEVALUE worked perfectly!   I've been wondering how to incorporate SWITCH into some of my DAX but I dont think it will always be possible e.g, how would I use it here: ...

How to find maximum of a text column with a distinct of 2 or 3 columns and calculate the sum

Hi  I need to find maximum of a text column with a distinct of 2 or 3 columns and calculate the sum of one column in power bi using a measure?

Get the latest record in an SCD2 for a unique ID, count unique IDS, within period set by date slicer

Hi all   I have been struggling with this challenge latetly.   My goal is to create a measure that count unique IDs that has the "Priority" of 1, within a set date period from the date ...

Re: ¿Cómo cambio el formato de fecha de una columna a "MMM-YY" en POWER QUERY?

Ojalá eso fuera todo. Desafortunadamente, esto da como resultado un valor de 4 dígitos sin letras, por ejemplo, 31.07.2022 se convierte en "00-22". ¿Puede deberse a una configuración regional incorre...

Re: Share your thoughts on visual calculations (preview)

Thanks for your reply. I totally understand that you are trying to hide the complexity. I actually expected that you would give me the "by design" answer. 😊   However, I do feel that it ...

Dataflow refresh history retention period

Does anybody know if it is possible to increase the time that Power BI keeps the refresh history for ? Typically on Monday morning our Support team will follow up any refresh error alerts from the...

Re: Power Automate: agregar filas al conjunto de datos

Sí, eso es lo que hace una actualización del modelo semántico.

How do I change a columns date format to "MMM-YY" in POWER QUERY?!

None of the tutorials I found so far work as presented.    I need to transform a column from dd-mm-yyyy to mmm-yy before merging it with another column, so it has to happen in the query e...

Gantt chart reference table

I am having difficulty and need the help of the community.  I have a Gantt chart that shows all of my scheduled events and so forth.  My issue is that my client wants a table with my Gantt ...

Re: Formato condicional (¿error?)

@marcoproserpio , Espero que tenga el año en el campo de columna del objeto visual de matriz anterior. En el formato condicional, usamos alguna función (Min/Max) en el valor categórico, por lo que p...

Addcolumn and vlookup

I just created a new calculated column (FY24_AOP_Rate) into the factable. I would like to simply multiple and sum the result. but the code below seems is not responding the calculation. what i am doi...

Re: Time Filter for previous 2 shifts.

Here is a sample table of data. The column on the far right "Wanted in the data set" shows the rows I want included in the data. The Shifts at the company I work are 10 hours with some time in betwe...

Re: How do I repeat row values in a matrix?

Seems like you want to change the stepped layout under options of row headers options.

Re: Sum some categories for the same date

It seems to work. Thank you all. It was also usefull the exemple!