Power BI-support
Sök
Re: Extraer valores
@parry2k en realidad son cuatro mesas. Entonces, ¿incrusto ese FILTRO en el DAX original pero como una nueva tabla? Debido a que el "No Match" en realidad no existe en el modelo.
Re: Measure with a filter clause
Hi @AK7 This should work, Leave = CALCULATE ( COUNT ( Leavers[ID]) , Leavers[Status] = "Leave" )
Re: Getting error message: The name 'LOOKUPVALUE' wasn't recognized. Make sure it's spelled correct
Thank you for the quick response. I was adding a column. AM I not adding the right thing? Here is the dialogue. Thak You!
Re: Aparece un mensaje de error: no se reconoció el nombre 'LOOKUPVALUE'. Asegúrate de que esté escrito correctamente
@CamJohnston Esperaba esto, está agregando una columna en Power Query y la función LOOKUPVALUE es una función DAX. Debe agregar una columna calculada usando DAX y ahí es donde usará LOOKUPVALUE ...
Re: Getting error message: The name 'LOOKUPVALUE' wasn't recognized. Make sure it's spelled correct
@CamJohnston I expected this, you are adding a column in Power Query and LOOKUPVALUE function is a DAX function. You need to add a calculated column using DAX and that's where you will use LOOKU...
Re: Suma acumulada para todo el mes hasta hoy, incluso si no existe un valor con un mes en los datos
@anom Como práctica recomendada, agregue una dimensión de fecha en el modelo y utilícela para cálculos de inteligencia de tiempo. Una vez agregada la dimensión de fecha, márquela como una tabla de fe...
Filter Data based on IF condition - 2 tables
Hello, I have a file called SKU guidance which is maintained on SharePoint. I added those Guidance values on Item table by using LOOKUPVALUE. Guidance = LOOKUPVALUE...
Re: View OLAP query running in Excel
@GilbertQ whenever I click the "Refresh" button it still tries to refresh all pivot tables connected to the data source, so it seems to do the same as if I clicked on "Refresh All" - is this bec...
Re: PBI Local data : Security query.
Hi @gauravchhaunker The localization is only for the way the languages are shown. If you want data to reside in a physical location you will have to use Power BI Prem...
Re: Puede conectarse a la API desde PBI Desktop pero no puede completar el ejemplo de CURL para el elemento binario de datos - H
let base_url = "https://hostname:443", api_key = " ", url = base_url & "/incidents/search", headers = [ #"Content-Type" = "application/json", #"Accept" = "applicat...
Re: On-premises gateway for OneNote file
I realize that this post has a solution attached, however a couple of options may be of interest to you in accessing OneNote. Use the OneNote REST API Rust OneNote® File...
Re: Fixing line chart shaded target area from trapezoid to rectangle
Not sure what happened to the decimals. Percentiles Value1 Value2 Target Lower 10 0 0 25 0 0 50 1 0 75 7 2 &nb...
Re: FUNCIÓN DE CALENDARIO
@parry2k, la fecha de finalización es mayor que la fecha de inicio. Esta es la fórmula que devuelve valores en blanco CALENDARIO([MENOR], [MAYOR]) MINOR es una medida calculada que devuelve la fec...
Re: cómo mostrar las cifras YTD en totales para los meses que han sucedido y excluir los meses que no lo han hecho.
@Thomasshepherd2 , Pruebe la medida para forzar el límite YTD QTY forzado = var _max = hoy() devolución if(max('Date'[Date])<=_max, calculate(Sum('order'[Qty]),DATESYTD('Date'[Date])), ...
Re: Date filter for x day in current quarter
Date.AddDays(Date.StartOfQuarter(DateTime.LocalNow()),14)
Re: PowerQuery: Reference a value to use as input for another M query
Name=Filename[Name]{0}
Re: report file corrupt or invalid
great, thank you very much!!!
Re: Show the Value from a Cell: using Dynamic Index || Count Dax Formula?
@Falaerm , have you check if new rownumber or rank function can help New DAX Function: Rownumber- https://www.youtube.com/watch?v=yS9-IQjUDwg&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=...
Re: show count of IDs that converge based on a second table
@MateusMontemor , You have to create an independent diconnected table with all projects Name = distinct(Project[Project Name]) // Do no join with your table Then you can create...
Re: Need help in choosing right Visual for showing Top 10 Accounts by Order count with multiple comm
HI @SwatKat, You can use the following measure formula with 'account' table 'account name' field, 'order detail' table 'comments' field with aggregate mode 'count' to create a table visual sho...
Re: Nombres de archivo de conjunto de datos
@vozniak , compruebe si los cmdlets de Power BI pueden ayudar https://docs.microsoft.com/en-us/powershell/power-bi/overview?view=powerbi-ps
Re: Problem extracting data from JSON
Simple enough let Source = Xml.Tables(Web.Contents("http://api.worldbank.org/v2/country"))[#"Attribute:pages"]{0}, Pages = Table.FromList({"1"..Source}, Splitter.SplitByNothing(), {"Page"}),...
Re: How to create a matrix visual without aggregation
Hi @PowerBINewbie_ , Please refer below links, hope it is helpful for you: Power BI Matrix table without data aggregation and single column filtering multiple columns. - YouTube power...
Re: Power BI dataflows (legacy) always return to 'private' when resave dataflow credential
@v-yetao1-msft , @v-xiaoyan-msft