Power BI Support
Search
Calcular la suma de horas desde el otro tabel entre hasta las fechas
Hola. Tengo 3 tabels 1 calendario 2 Empleado 3 Absentismo En mi calendario, tengo las horas estándar por día. En mi ausentismo tengo un StartAbsenDate y StopAbsenDate Quiero calcula...
Need Power shell script to know what are the power bi dashboard using by user
Hii Thanks in advance .I need the script to know what are the power bi dashboard using by user .
Calculate sum of hours from annother tabel between to dates
Hi. I have 3 tabels 1 Calender 2 Employee 3 Absenteeism In my Calender, I have the Standard Hours per day. In my Absenteeism I have a StartAbsenDate and StopAbsenDate I want to c...
Re: Transformación para este tipo de tabla
@ryan_maju, Lo siento, cambio mi muestra para agregar en el año como dejé fuera anteriormente. Esta es la muestra y estoy tratando de obtener algo similar a ti. Sin embargo, cuando despivoto y hago...
Re: Dynamic union queries based on list of DB names
Hi there, Sure. This can probably be done a bit cleaner than what I did. But here you go (comments in the code). let // Define a parameter named "DatabaseList" that contains a...
dax | to maintain measure values while stil changing the period visual slicers
hi, i have managed to get a measure working for the latest date as follows. Ar-Act-LD = VAR LatestDate = [LastTransactionDate] RETURN CALCULATE ( ...
Re: JSON Theme: Parámetro para establecer el esquema de la casilla de verificación de Slicer
Desafortunadamente, esto no ayudó, ya que no creo que la interfaz de usuario ofrezca la posibilidad de cambiar el color del esquema.
Re: How do I verify the content of a column based on a number of most frequent values?
My goal is to create a measure that writes a 1 or 0 in a separate column. Measure function: Filter out all employees from a project who are not in the same office as the project manag...
Re: Sorting in Treemap chart
Yes @Ahmedx exactly like this! 🙂
Cómo crear un conjunto de datos compartido de Power BI desde una aplicación web
Hola Hemos planeado almacenar algunos detalles de configuración de Power BI en nuestro archivo de configuración de la aplicación web. Desde ese archivo de configuración leeremos los datos y necesita...
Re: Icono url que no aparece en la tabla
gracias, funciona eso me faltaba
Unique list values in filter and when multiple values selected should filter comma seperated entry
i have a list of tags some of which are comma-separated as shown in the image below when I use the same column in the filter it shows comma-separated entries as well as shown b...
First transaction of the week by customer - calculated column
Hi everyone, I am wanting to create a calculated column where I want to locate the first rowcount of the week for every individual customer, and mark it with a "0". Then for all other counts till the...
The report is showing old value even after incremental refresh
Hi Team, We have a dataset with import mode tables, we have added incremental refresh on the fact tables. when we execute the report one of the measure is still showing old values, whereas t...
Re: Elimine el nombre de encabezado de fila vacío de la matriz que tiene 2 medidas diferentes.
Lo siento @Idrissshatila pero no funciona
Re: Elimine el nombre de encabezado de fila vacío de la matriz que tiene 2 medidas diferentes.
Hola @Swapnil_Palekar , Intente filtrar la medida para que no se muestre en blanco desde el panel Filtro Si respondí a su pregunta, marque mi publicación como solución para que apare...
Re: Help with Time Intelligence using Fiscal Years
hi @Isnaan_Ahmed try like: _OrderedUnits Last FY = VAR _SelectedFY = SELECTEDVALUE ( _FiscalDates[Fiscal Year (544)] ) RETURN CALCULATE( [01. Ordered Units], _Fiscal...
Re: bring currency value by using lookupvalue condition where period = M
Please tell me this thing.
Re: How to count cumulative on graph
Yes, it is possible to create a DAX formula to count cumulative totals in Power BI. You can use the following formula: Cumulative Total = CALCULATE(SUM(Table[Value]), FILTER(ALLSELECTED(Table), Tabl...
Date filter
I need to make a date filter and automatically filtered by last seven days without ignoring the rest of the dates in power bi? i tried to do using many ways but could not so i need any approved ideas
Suma columnas específicas de una matriz
Hola comunidad, Quiero crear una matriz que muestre cuántas personas estaban activas en una determinada dirección en un momento dado, sin embargo, SUMA ciertas direcciones como regiones específic...
Re: Unable to use parameter in query2 which uses query1 to get parameter values
@ShaliniUpputell he Formula.Firewall function in Power Query is used to control data privacy by preventing certain types of operations that can potentially expose sensitive data. It is...
Re: Sum Total issue
This issue could be caused by floating-point precision errors. When adding or subtracting numbers with many decimal places, the result may not be exactly what you expect due to the limited pr...
Problema con el filtro import y directQuery en la visualización
¡Hola! Estoy tratando de filtrar simplemente una visualización de tabla con otra visualización de dos tablas unidas por una conexión de modelo 1-1 Both. En este caso solo trato de probar entre ...
Re: Count most recent and consecutive streak of values IF values are <1
Hi FreemanZ, Unfortunately, the ones that have only blanks are the one with get a count of 52 (52weeks). It works great for the other ones though, as you can see from my screenshot below. ...