Power BI Support
Search
Re: Confused about DateADD around another measure
You're partially right about the inner filter context overwriting the outer one if they are on the same column, but I think only when you're providing a table of values as the filter. DATESYTD return...
Valor predeterminado para el menú desplegable Tipo de filtro
¿Hay alguna manera de establecer un valor predeterminado global para que el filtrado básico siempre se seleccione primero para el tipo de filtro?
Re: Get latest date from one column based on a value from another column.
@L_K_ , Try if these logics can help https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0 https://amitchandak.medium.com/power-bi-get-the-sum-of-...
Re: How do I share a report so non-PowerBI users can use it?
Do you use Office 356? I open my admin panel through it. Once you publish your report it will be publicly available.
Rolling values per category
I need help with DAX. I have this table: business unit year_month category amount amount all categories 12 month rolling sum 12 month rolling sum all categories...
Nested if statement based on dates for New Column
Hope you can kindly assist. I'm trying to write a nested if statement for a new column I created, but I'm having trouble with the syntax. My new column is called "WEEK #" where it is the number of we...
Re: How to model "current month" so conditional formats are ignored in future months of Ma
That looks promising and I'll give it a try. However, my "current month" is a value from my data , not the actual date. I am struggling with how and where to store that info.
Re: Jerarquía de fechas como filtro
@gabriel2605 Debería funcionar. Acabo de probarlo. ¿Puede asegurarse de que sus tablas tengan la relación correcta?
Re: Filtrar un objeto visual para mostrar datos de fechas anteriores a la fecha seleccionada
Muchas gracias por compartir esto. Realmente funcionó. La única advertencia es que los totales del año se muestran en blanco, sin embargo, se filtran correctamente.
Re: How to custom only end date in slicer date
Please try the following:
Re: Filtrar por un valor para ver todas las instancias relacionadas
@Liam01 , Trazar una medida como belwo con número de pedido calculate(Count(Table[Order]), filter(Table, Table[Product] = "AB"))
Re: Ventas del año pasado (LY)
@amitchandak , ¡Funciona! ¡Muchas gracias!
Datamart with Dataset
Hi, Is it possible to connect a dataset to a datamart in Power BI Service ?
DAX formula causes 'Resource Governing' Error message
Hello, I have a DAX formula for a measure that has been working fine but I need to modify it. The .pbix file is a data model that gets published and the dataset is used by Report Builder ...
Re: Nested if statement based on dates for New Column
Thank you! That is so much easier 🙂
Re: Ventas del año pasado (LY)
@Oros , ya que es YTD Prueba como CALCULATE(SUM('SALES-TABLE'[SALES]),dateadd('Calendario'[Fecha],-1,Año) ) Inteligencia de tiempo, parte de aprender Power BI https://youtu.be/cN8AO...
Re: Load large data from Cosmos DB into Power BI
@I554642 , refer if this can help https://www.phdata.io/blog/loading-large-datasets-power-bi-using-parameters/ https://towardsdatascience.com/change-your-approach-with-large-datasets-in-power-bi-...
how can i automate a process to get data from a folder
i would like to automate a process to get data from a spefic folder from then i would set up schedule refresh.
Re: Average Days Between Inspections
@tamerj1 , Apologies, I mean the measure!
Unable to connect Excel Power Query to SAP BW OLAP
Hi team, I am trying to connect Excel/PQ to SAP BW multidimentional data source. I have installed the latest version of SAP BW ODBO driver (64 bit). Using Excel Get Data > From OLEDB option...
Re: Cumulative sum by month per products
any help please
Re: Compare two measures to evaluate dimension status
@b2wise , Dont forget to accept the correct answers so it can help others.
Re: Quickinfo while hovering over Textbox
Hi there, thanks for your quick respond. What I actualy meant is when I hover over a visual, like in the screenshot underneth, I can see another visual popping out (Quickinfo). The same e...
Re: Export list of applications "Users"
To date there is no way to export users with access for each Report, a tip that may help is to use the "Web Selection" tool of Microsoft edge.