Power BI 支持

搜索

Re: DAX formula help - Advanced level

Hi @ppgandhi11   I have a book that can help you with that at aka.ms/PracticalDax   But the quick answer is that the MAX() function is just shorthand for grabbing the value from th...

Re: Problems publishing report from desktop

I've encountered the same problem as you today. Not sure is this due to the Jun Desktop update version.    

Re: Use row-level security (RSL) need to set for embedded report

Hi @mayank08,   Please mark the private information. May I ask if it's necessary to use two conditions? You can do it in the local application. For example, even if there are two user...

Re: unable to refresh data for web data source

Hi @ganesh_simhadri,   Would you please share the pbix file with us so we can try to test n our side? You can upload to your OneDrive and send the link to me via private message.  ...

Re: YTD of years until today

Thanks for your reply! I've been working with the Time Intelligence function that you sent, this has helped me calculate the difference from years before. Yet I am facing one more problem. this is m...

Building a Custom KPI filter

Hello,  I got stuck, so I would greatly appreciate your wisdom.   I am trying to create a metric TREND as a calculated column so i can create a filter later from it. It works well a...

Re: Total Column (in Matrix visual) resizing after blank data is displayed in the table.

Hi @v-qiuyu-msft,   Have you managed to replicate the issue with the included work book? Happy to provide some more information if needed?   Cheers,  Alex

Re: How to count all clients beyond/without two last months?

@MarkShu, Try this one....   Concatenate Year and Month No. and this referes to Year(Last Active Date) and Month(LastActiveDate) respectively   ie. YearMonth =  2018 - Apr looks ...

Re: How to pass slicer(filter) values from page report to another report(not one page to another pag

Hi @Nagaraju, Drill-through filters are available in Power BI except that the way you will implement is different.   In IBM Cognos, you will have it as two different reports, but in Powe...

How to count all clients beyond/without two last months?

I have found: all clients - CALCULATE(COUNTA('Outflow'[ID]);ALLSELECTED('Outflow'[LastActiveDate]))  previous month clients - CALCULATE(COUNTA( ' Outflow '[ID] );PREVIOUSMONTH(DATESMTD(...

Re: How to I get data type "mvarchar" and "mchar" in PowerBI?

@livesid,   You may try using CAST to convert data type in SQL statement.

Table relationship

Hi,   I'm trying to link data in order to built a revenue:margin report but havent been able to link my two tables. I have the following two tables in excel, different tabs:   Revenue ...

Re: Need help with Dax Formula; Displays right row results, but wrong total

@GSinghking, Please use one of the following DAX. NewMeasure = IF(COUNTROWS(VALUES(Sales[ID]))=1, [final calculation],SUMX(VALUES(Sales[ID]),[final calculation])) NewMeasure = IF(COUNTROWS...

Re: convert calclulated column datatype text to decimal number

Hi Kunuthuri,   If you don't want to change the format of [Hours Between], maybe you can try the formula below. Measure = VAR total = SUMX ( SUMMARIZE ( 'table', ...

Re: Cumulative calculation issue

Sorry Dale I should have clarified, I have tried replacing the blanks with zeros, and since its a measure it provides s0 for months I dot not want to show.

Re: Azure Data Lake refresh issue

I'm experiencing the same issue - simple query but no option to schedule refresh in the Service.   Unable to refresh the model (id=4097221) because it references an unsupported data source

Re: subtotals are less than sum of column values

This solved the column total issue but the row totals are still wrong.  This appears to be summing the Total SD Activities measure for each cell.  I assume the theory is that when it hits t...

Re: Unable to Connect to VIEW on Amazon Redshift

  Hey davidbrown100,   I doubt Microsoft will address this issue anytime soon - here are workarounds.   My solution - right now I am moving data into a "datawarehouse" schema to ma...

Range Slicer + Dynamic KPIs

Hi All,   I am trying to do a dynamic KPI that would depend on the dates selected in the slicer. The problem I have is that When I select a single month, the values are being displayed correct...

Can we use ODBC driver with Power BI web?

Hi There,   we just started using power bi and we are using the Power BI web version. We have a requirement that we need to show our service now change request data on power bi report. So we w...

Re: SLA Reporting Help - Calculated Column Formula?

Hi, as far as I see this problem, you should use DATEDIFF function to calculate difference between dates. In it"s 3rd parameter you can set the difference to a hour based format.  After that y...

Re: Individual average divided by Team Average

The formula you're looking for is technically "average of completed requests per day per team member", so you can take your existing formula as-is, and divide by a distinct count of team member names...

Re: Unpivoting?

Hi Aron, thx for your input, but it doesn't solve the issue I'm afraid, as this puts for instance for Staff1 the attributes in different rows, whereas we want them in column...

Plotting dates on line chart

Hi, I want to achieve the below in Power BI. I tried the line chart and added Month to Axis and "Cat 1 Date" to Values and when I did that, PBI automatically counts the data values. Appreciate y...