Support Power BI

Rechercher

Re: TimeStamp

You can select "Short time" format from column tools menu in power bi desktop.  

Connecting Microsoft Form to Power BI

Hello,    I'm trying to connect my microsoft form data to Power BI, i tried following this tutorial : Easiest Way to Connect to Microsoft Forms Data in Power BI - BI Elite and m...

Share Power BI Dashboard slider without Premium Capacity

Hi, I want to share one of the slides from my power bi dashboard with Selected people via mail. I looked for a solution using power automate but it does require a license of $5000 / month. I was loo...

Filter based on a existing measure.

I have a measure that is created to calculate the number of years from the time an asset is purchased.  Warranty in Years = CALCULATE ( DATEDIFF ( SELECTEDVALUE ( 'Configuration Item'...

Re: Creating table containing future data based on rules

ve this a try :  Expected Invoice = var start_date = MIN(Contracts[Starting Date]) var invoice_period = MAX(Contracts[Invoice Period]) var invoice_value = MAX(Contracts[Contract Value]) r...

Creating table containing future data based on rules

Dear All,  I need to pick your brains on this one: I have a table containing contract Id, contract value, contract starting date and invoice frequency (monthly, bimonthly, quarterly, every 6 m...

Re: PowerBI Shared reports

Hi,   For this, you may need to make the Oracle database accessible from the cloud. This may involve configuring network security groups or firewalls to allow traffic from the cloud environmen...

Re: Modifying DAX Code for retrieve full data

hi @sammy02hk  try like: ... var LLMonth - DATEADD(MAX(Monthly_All[Billing_Month]),-2,MONTH) ...

Re: Tener el registro anterior y el siguiente registro en la lista

¡Gracias querido Olgad! Tengo 250 pozos y crear marcadores no es fácil. Su segunda solución fue interesante. Se lo envié a mi gerente. ¡Muchas gracias de nuevo!

Re: Dax help

Hi @mysmsr ,   Please try: Rolling FC (Bias) = CALCULATE ( [Rolling FC], OFFSET ( -3, ALLSELECTED ( 'FY Table'[Month] ), ORDERBY ( 'FY Table'[Mont...

Re: Cummulative value from startDate

Hello, i really tried now to figure my the issues out - but I can't manage to come close to the result that i would like to see in your example.   I uploaded the small pbix file to my google ...

Re: Can't get connected

I made a number of trials and I have it working now, Thank you very much,  I will mark this as the solution, 

Re: Value from table changes when displayed on Visual

@Mumiah , DAX is not best for duration sum.   Refer these option   Duration https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-d...

Re: Value not change according to month but remain contant, how to solve it?

i found the solution. The relationship was not established previously. Now the problem is fixed.

Re: Slicer Drop Down List filtered - can I bulk select?

@unembielby , I doubt that. But you can check text Filter https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview   Text Filter Slicer and how ...

Re: PBI Web not displaying properly - Desktop works fine - Status changed to: Investigating

Hi @Craig_H ,   We are unable to reproduce your issue, does the problem occur in this one report or does the problem occur in all reports in this workspace? Is the report applying...

Re: Customer Voice - Matrix Question relating back to Parent question

I'm having a similar issue. I have related the appropriate tables in Power BI, but for matrix type questions, the "Questiontext" values are null, making it impossible to pivot by question text. ...

La segmentación de datos de PowerBI no funciona

Hola equipo, Estoy tratando de usar slicer desde powerbi desktop pero no funciona o no muestra la opción de fecha relativa en el filiter, me gustaría al especialista powerbi inmediatamente, mañana...

Cómo transformar el espacio en blanco en 0 en matriz

Creé una matriz y arrastré la medida a valores, pero hay muchos espacios en blanco en las celdas, creé una medida para transformarla en 0 pero no funciona, ¿hay otra forma de convertir el espacio en ...

Re: Gestión de datos

@jman738 , En caso de que desee en alguna máquina local, necesita una puerta de enlace local para actualizar los datos. En el caso del punto compartido, no lo necesita. Pero tienes que actualizar los...

Re: Contar el vehículo de tráfico de bandera basado en el período

@chrisyan_manalu , consulte si este enfoque puede ayudar Medir camino Power BI Dax Measure: asignar datos entre rangos: https://youtu.be/O653vwLTUzM Power BI: Análisis de recursos humanos: e...

Re: Calculate Formula Shows filtered data

Hello, I was just trying different things. Even with one direction it is still the same

Re: Cumulative Line appears to resest on another field. How to stop?

@Mjdrejza1722 , use a date table and try   OnlySpend Cumulative 2 = CALCULATE( SUM('table1'[Amount]), ALLSELECTED('Date'), 'Date'[DATE]<= MAX('Date'[DATE]) )   or   ...

Re: Userrelationship / ParrallelPeriod wrong subtotals

@MarcW , Try like   Var _measure = CALCULATE( [Annual Pay] ,USERELATIONSHIP( WorkDay[SourceDate], 'Date'[Date] ) ) VAR Result = CALCULATE( _measure, Dateadd('Date'[Date], -1, year) )...