Power BI Support
Search
Re: Crear columna que muestre la diferencia de datos en comparación con la semana pasada en formato de fecha (AAAAWK)
Eh Me las he arreglado ahora. Muchas gracias a todos por la ayuda. Si alguien está interesado, aquí está el código que utilicé con la ayuda de @TonyZhou1980. Simplemente reemplace SUB-C con sus pr...
Re: Matrix colum headers out of order
@coliveira2001 Try sorting the A,B,C values from the relevant table in Alphabetical order using Power Query and check again
Re: By default the first occuring value from a table details should be seen in the other table
@amitchandak The Problem is i have two tables i.e Event Name table and Event Analysis Table The Event name consist of Top 10 events and its corresponding percentage where as the Event A...
Re: DAX formula for "first error" column
@amitchandak Thank for your rapid feedback! I tried your approach with real data and figured out that most of my requirements are covered with only one exception: In this case... 1004 &...
Re: fórmula DAX para la columna "primer error"
@Mahesh0016 Gracias por su enfoque. Pero todavía tengo el problema restante que ya mencioné a continuación.
Re: MRR Analysis for SaaS (Churn, expansion, contraction)
@JBB22 < For Customer retention refers, if these can help, for MRR what is the logic? Customer Retention Part 1: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part...
Re: Crear una nueva tabla basada en sectores de inicio/fin del período
Gracias, pero eso no funcionó; La tabla filtrada quedó en blanco. He probado la opción de filtro antes. Necesito la tabla también, así que cuando haga mi Matrix visual, vendrá con solo los meses en ...
Re: Have graph reflect forecast based on Month-end Date
Hi, I am not looking to sum, just graph the month's actuals and then forecast if not actuals. Attached is a screenshot of my graph and table data. To get this graph, it's 2 lines...
Levantar un indicador cuando el ID seleccionado por el usuario existe en una ruta o cadena
Hola Tengo una tabla de artículos y una tabla de productos. En la tabla de productos tengo una columna donde todos los elementos necesarios para construir el producto se enumeran de A_B_C maner...
Re: Análisis MRR para SaaS (Churn, expansión, contracción)
@JBB22 < Para la retención de clientes se refiere, si estos pueden ayudar, para MRR, ¿cuál es la lógica? Retención de clientes Parte 1: https://community.powerbi.com/t5/Community-Blog/Custo...
Resalte más de dos fechas provenientes de tablas relacionadas
Tengo dos fechas, cada una proveniente de una tabla diferente (relacionada). Quiero poder resaltar la fecha acc_MRG si es mayor que la fecha con_MRG.
Power querry Next 1 Month
Hi I would like to create a formula like that , (in the same year) if today's month name is equal to next month's name[TEYİT TAR] then TEYİT TAR. else 0 I would be happy if you could help me...
Re: save data from web
@aviv5777 It seems that you are looking for historical currency data. If this is the case then you can have a look at the following 2 posts: https://community.powerbi.com/t5/Serv...
Re: Summarize tags from orders to customers table
Hey @JorgePinho Thank you for your answer! I want to add this to my existing customer table as a column. For information, my tag is a non numerical value. Thank you!
Learn how easy to get Top N selling products using new WINDOW DAX functions in Power BI
Since new WINDOW DAX functions are introduced I have done many videos exploring these functions using various use cases explaining when to use OFFSET, INDEX, and WINDOW functions. In this ...
Re: Columna calculada utilizada para la evaluación comparativa ignorando el filtro/segmentación de datos
¡Gracias! @sturlaws Funciona ahora
How to connect the same report to different database depending on the user's credentials
Hello, As asked in the title i want to connect my report to different database depending of the user. Lets say i have 3 identical Databases (not same data), 1 for each client. I ha...
Re: Implement RLS in Push Dataset using API
This issue is still relevant! Turnsout you cannot set RLS for streaming datasets, push datasets seem to still be unaccesible and the only way of creating a dataset supporting rls and something simila...
Re: Lowest Sale Date
hi @Syndicate_Admin Supposing you have two columns in sales table: date and amt. try to create a measure like: LowestDay = VAR _lowestsales = CALCULATE(MIN(TableName[amt])...
Re: Fecha de venta más baja
@Syndicate_Admin Supongamos que tiene dos columnas en la tabla de ventas: fecha y amt. Intenta crear una medida como: LowestDay = DONDE _lowestsales = CALCULATE(MIN(TableName[amt]), ALL(...
Power Query Group By/Aggregate based on condition + dynamic columns
I have a table with products (Cols E-F) from 3 countries (Col A), with weekly values (Cols H-L) and condition (Col G) based on which I need to aggregate the weekly values, and also display the aggreg...
Re: How to get the sum from an existing measure (preferably within the same measure)
Hi @knockmania Please check this if it helps you solve your problem https://www.youtube.com/watch?v=dgwsk2fjWLc
Re: La lista Table.ReplaceValue no reemplaza los datos nulos de forma coherente
No puedo reproducir este comportamiento. ¿Cuál es el caso más simple en el que puedes? Esto es lo que intenté: let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText...
I need help Sort column Contains numbers and text in Power BI
I need help sorting data in Power PI like the original data. I tried to use the index, but it didn't work. I'll put the pictures below for clarification : this is the original data an...
how to exlude text from formula
Hello All, I have the following table: Name Value CocaLight 5 CocaZero 6 Zero 3 Extra 1 PesMax 2 I want to calculate the sum of the values but ex...