Поддержка Power BI

Re: Concurrent notebooks in a pipeline

Hi @Ostrzak    Thanks for using Microsoft Fabric Community.   Apologies for the issue you have been facing.  Could you please share me the error details which you a...

Re: Running Balance

Hello! I suggest creating your calculated (NET) column in Power Query instead or creating a measure for it instead, it will be better for performance. For the running total, try creating the below me...

Re: un parámetro que intercambia valores para dos conjuntos de datos diferentes.

Esto se puede lograr. Debe crear 3 dimensiones comunes: LeadSource, Manager y Department. Dimensión común = Dimensión utilizada por varios conjuntos de datos, normalmente tablas de hechos. Siga es...

Re: Automate Hierarchy Slicer

@Shannon_Leong What's your data source look like? Sounds like it's in the format that works well with SANKEY visual, but not hierarchical slicer. https://excelwithallison.blogspot.com/2021/...

Re: nombres de columna para gráficos agrupados basados en medidas

@Javierco , Cree un grupo de cálculo y puede obtener algo como esto A partir de ahora, hay algún problema con la etiqueta personalizada en mi extremo, de lo contrario, creo que el...

Re: Recuento acumulado con AllSELECTED

@NAOS , crea una tabla de fechas separada y únela con tu fecha y úsala Cumulative_count = CALCULAR ( COUNTROWS ( 'Registros' ), FILTER ( ALLSELECTED ( 'Fecha' ), 'Fecha'[Fecha] <= MAX ( 'F...

Combining tables

Dear All,   I have three tables as below.    1st table   ,    2nd table   , 3rd table   Is there a way to get these three tables to a o...

Re: Conditionally Format Bar Colour Within a Small Multiple

All good, thanks @Uzi2019 

Re: Average growth just for the selected time period (Problem with DATEADD)

Hi @scoobydoo , Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula. How...

Re: DAX cmd/filters to only include results that exist in both academic years & quarters but dif

Hi @TravellingMagpi , Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula....

Re: KPI de medida de este mes frente al mes anterior

Muchas gracias @amitchandak aunque me da el mismo resultado Saludos Ritesh

Re: DAX no se ejecuta%

¡Hola, @tonyc use la función ALL. Por ejemplo: UN PESO CY = CALCULAR( [UN PESO%], FILTRO( ALL('Fecha'), 'Fecha'[Año] = MAX('Fecha'[Año]) ) ) Esto debería eliminar los filtr...

Re: Latest Test Result

Awesome, that worked. Thank you so much!

Re: Date format in slicer (to show dd/mm/yyyy)

Hello, I've managed to resolve this on my end by changing the Chrome language settings, then removing English(United States) from preferred languages.   Hope that helps  

Re: Lookup multiple times until got the right value

Hi, @Mars3442    yeah, you can. Do merge in PQ editor.    merge the master data with data customer based on the product code customer This will give you the ...

Re: Create a table of "sumif" and sum values based on an existing table

Hi @saira-b    Can you post sample data as text? Your Excel Sheet1 data Not enough information to go on; please see this post regarding How to Get Your Question Answered Quickly:...

Re: Invalid Username and password for dataflow

Hi @Satyam916  1.When you input the useraccount, you need to input the domain\username, you can open the cmd, and input 'whoami' to find your domain\username, then put it to the username ...

I am unable to get my query to run due to an issue with my replaced value.

I am sure it is my own error, as I am new, but I do not recall changing anything.  The replace values I need to allow the column to remain, but the row data needs to be blanked out. I found a t...

Necesito ayuda con la importación de la imagen por parte local

Hola chicos, importé las banderas locales a Power Bi. Una vez importado, creé la relación entre la tabla de importación de banderas y la tabla en mi base de datos. La relación es una relación (*:1) ...

Need Help whit import of image by local

Hi guys, I imported the local flags into Power Bi. Once imported I created the relationship between the flag import table and the table in my db. The relationship is a (*:1) relationship that filter...

Re: Cálculo del total general

...ivisión - Microsoft Fabric Community Saludos Esteban Tao Si esta publicación ayuda, considere Aceptarlo como la solución para ayudar a los otros miembros a encontrarlo más rápidamente.

PROMEDIOX con un RANGO

Estimada comunidad, He creado una medida RANK para clasificar los datos en función de las columnas seleccionadas, con un contexto de fila: si agrego otro país, este país se tendrá en cuenta y se...

Re: Dynamic date in Odata query

Hi, I want to change date format in Odata query. It is taking value in format YYYY-MM-DD.  example of Odata query from Microsoft:  let Source = OData.Feed ("https://analytics.dev....

Re: Cálculo del gráfico de líneas mensuales

Sí, solo se usan tres tablas, vea la imagen, los datos están seguros por esta razón no puedo compartir el modelo.

Re: Exchange rates over time - model attached

I solved this myself by importing a historial exchange rate table from investing.com (with ALL dates ranging from 2019 to 2022) and then following this guide:    https://www.youtube.com/w...