Soporte técnico de Power BI

Buscar

Re: How to calculate a new column to plot the number of hours elapsed Vs Fuel consumed

should the [Previous] in the DATEDIFF function be just prevous?

Re: Split Column by delimiter, add row but empty values

@thomastatum, You can copy and paste this code into your Advanced Editor for reference let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCkpNUdJRMjQwAZKhwUqxOtFKT...

Re: Unrelated rows added to table when adding text measure to star schema?

I'm looking at this more today.  It looks more and more like adding the constant text measure caused a cross join.   *scratches head*

Re: Dataset refresh from OneDrive Excel file set-up

Thanks Gilbert and Maggie,   The issue is resolved now. For some reason, OAuth2 was not populated as an option for 'Authentication Method' in DataSource Credentials when I had posted my issue....

Need help in Measure for % Calculation

Hi,   I have a data like below,   Name Rating QTR ABC 5 Q1 CDE 6 Q1 ABC 6 Q2 BCD 6 Q2 CDE 3 Q2   and need something like below: If filtered by Q...

Re: Power BI Desktop fails to open after June 2018 Update

Hi @GraphixLL   If you can reach to Options , Try unchecking all preview features from File -> Options-> Preview. We faced the similar issue earlier and this did the trick for us.  ...

Re: Date Slicer - Sychronized - Moving Forward One Day

I am having the exact same issue. Only in the service. I also had a simple measure that I wanted displayed in a card but it wouldn't display in the service. The date thing is definitely a huge issue...

How to sum values in a column if they have the same ID in another column

Hi  I want to add the weight column if they have same PO number. For Eg. The same PO have the weight categorized at item level. Below is a sample of data. I want the total weight for each PO...

Re: How to avoid "blank" when I use a another visual object as Filter?going crazy with thi

Hi @christianfcbmx,   Replace the column count by the following measure formula:   Cerrados = COUNT(t_problemas[F. cierre real]) + 0 See screen below:   Regards, MF...

Re: Hierarchy with non aggregated values

HI @HassanI,   I have some trouble to access the your file, please upload to onedrive or google drive and share link here. Notice: do mask on sensitive data before sharing   R...

Re: Oracle COnnection error in PBIRS

It's Solved same Issue for me.   This issue we can't fix in Power BI Server, we need to fix this in Power BI Desktop itself, because we can't change the datasource in Power BI server once we p...

Re: Looking for advice to choice a suitable visual

@JellevdWerff, @v-chuncz-msft   The following measure works perfectly. I check the calculation and it is ok. No problem at this stage.   TotalStockAtDate = CALCULATE(AVERAGE(StockValues...

how create new report based on existing data set (power bi online)

i want to design new report based on the existing data set published online. but i can't upload my Json file. Thanks for support!   Cédric.

Re: SharePoint List Access to resource is forbidden

@aalfa, Are you able to access the sharepoint list online in the site location where it is present.   If there is some issue with your access to the sharepoint list, even there you shouldn't ...

Re: How to write query in power BI Desktop with Amazon redshift connection

This is an issue here as well. Enabling writing SQL directly against the Redshift datawarehouse would bring it to feature parity with the other database connectors. As it is, I'm using a workaround o...

I am looking to return the next working day as tomorrow in a Power BI column.

I am looking to return the next working day as tomorrow in a Power BI column. I have the formula that works for Monday to Thursday, however, on a Friday it returns Saturday. Instead i would like...

Re: Data Model in Service duplicating and replacing rows

Hoping the team got in touch with you @Ehren. Spent nearly an hour convincing them it wasn't the workspace, my browser,  and renaming and republishing the report also wasn't the fix. Hon...

Re: Slicer to filter for products bought in future transactions

Hi @johnconnor92 From your dataset, I can't see how to create relationship between "Products" and "Table1" tables.   Best Regards Maggie

Show Week-over-Week % increase in Matrix visual?

Hi all, I'm trying to show the Week-over-week % increase in a Matrix visualization. I created two Measures for each Metric I want to show, one for Last week, and one for Current week.    ...

Re: New Measure with a cross filter

Measure = CALCULATE(SUM(('TIME TRACKING VALUES'[LinkToTxnID], FILTER('Transaction Line Attributes'[Billable Status])))/SUM('TIME TRACKING VALUES'[Hours])     this is my most recent attem...

Re: DAX to Pivot data

I got this working, but need help on fine-tuning the formula.  Note:- I have more than 35M records in my table.   Def Revenue (M) = VAR Month_Start = SELECTEDVALUE('Fact - Table'[recogn...

Re: write sql join between two tables from different server in power BI query editor

You need to create a bridge/ relationship table.   Thanks Raj

Re: Lines.FromBinary(Web.Contents . . .

Hi @gagan1, You can copy and paste this into your Advanced Editor for reference: let Source = Json.Document(Web.Contents("http://inform.jrc.ec.europa.eu/GNASYSTEM/api001.aspx?workflow=258&...