Power BI Support
Search
Re: Goup by and count occurences meassure
@Ramon_CN Use this meaure: Num pX = TRUE() IN VALUES( TableName[PX] )
Re: How to create a new column in a table by referring to another table column using DAX
@Fowmy Thank you for the quick response. I'm getting this error- A single value for column 'neighbourhood' in table 'listings_summary' cannot be determined. This can happen when a measure formu...
Re: Total acumulado
¿Es esto lo que estás buscando?
Re: Large data model guidance: concatenated fields and compression
This is similar to the discussion about storing datetime values in separate tables for the date and time part. You will of course need a sacrificial lamb - an index column that actually ties th...
Re: how to create multiple icons in one column of a matrix
Hello @Jeremy19 , you can also refer to this video to add stars to your matrix https://youtu.be/rOjEFWDoooQ?si=stxeSecPgy_XeXlT
Re: DAX SelectedValue With If
@FreemanZ Thanks for reply. I need to show also the value that is at zero, something like this
Organización de varios grupos de cálculo
Hola a todos, esperaba que alguien pudiera ayudarme con una pregunta rápida sobre los grupos de cálculo en un modelo en el que he estado trabajando. Cualquier ayuda o confirmación de mis suposiciones...
Can access be provided to a specific data factory pipeline in Fabric to an external organization
I have created a pipeline within Fabric and I'd like an external organization to have access to trigger the pipeline. Is that possible or would I need to create such a pipeline in Azure Data Factory ...
Re: Direct query parameter based
How would the user pass a specific ticket number for data retrieval ? I cannot pull all the 10 mill tickets data using direct query.
Re: Subration of 3 measures with a condition
Hi @Benedictmooray , Without any data is difficult to give you a correct answer. Can you please share a mockup data or sample of your PBIX file with expected result. Y...
Re: Limitar Gantt al mes anterior, al mes actual y al mes siguiente
@rosie1931 , La mejor opción es crear una columna de bandera en la que identifique si los valores de las fechas están dentro del mes anterior, igual y siguiente, y luego simplemente filtre su g...
Re: Cómo calcular el porcentaje de los ingresos en comparación con el total
Gracias y también pensé que la columna calculada, ¡pero debería ser medida!
replicate calculation from datorama
Any suggestion to replicate the below formula to power bi? FORMATDATE(DATEADD('m', 1, Custom Month), 'MMM yyyy')
Re: can't open pbit template
Hi @XUXiping , We tried to reproduce the problem under the version (2.123.742.0 64-bit (November 2023)), but we were unable to reproduce it. To troubleshoot the problem further, please provi...
Re: Create new column to check the duplication with certain condition
This REQUIRES that the data is sorted exactly how it is shown in your example. It also assumes Accrual always sorts before Actual as well. That should be the case if it is in alphabetical...
Re: Ayuda con los filtros
@ACol123 , No puede borrar la selección en una segmentación de datos en función de la selección de otra segmentación, puede filtrar una segmentación de datos en función de otra, sin embargo, si...
Re: Calculation in DAX or Power Query based on Excel formula
@LadyPeshet Here a sample code: Diff Amount = VAR CurrentRow = YourTable[Monthly Amount] VAR PreviousDiff = IF(MAX(YourTable[Month]) MIN(YourTable[Month]), LOOKUPVALUE(YourTable[D...
Re: Add conditional column using mesure to pic specific value and create new colum
Correction - If the "Pass/Fail" value contains "Fail" than it should returm "Fail".
Re: Dataflow Gen2 Mashup Error
Same result.
Re: Declaración IF entre 2 TABLAS y MÚLTIPLES condiciones
@ladeko será más fácil si pones algunos datos de muestra con el resultado esperado.
Re: Power BI Azure user access report
Hey @Galz , unfortunately, this is not possible, but you can create this report using Power BI's REST API calls, like this one: https://learn.microsoft.com/en-us/rest/api/power...
Re: Ayuda para crear una instrucción IF con MÚLTIPLES CONDICIONES y FORMATO CONDICIONAL
@ladeko Por favor, proporcione los datos de muestra y el resultado esperado
Re: Goup by and count occurences meassure
i think that is a typo, this shall work: measure = TRUE in VALUES(data[PX])
Re: Los datos que faltan solo aparecen cuando selecciono un conjunto de datos en la leyenda
Porque tiene demasiados puntos de datos y Power BI está empleando agrupación y muestreo forzados. Utilice menos puntos de datos.
Re: Help with projection
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). Do not include sensitive information or anything not related to the issue or que...