Power BI Desteği

Arama

Re: SUMX with modifications

So, something like:   Measure = VAR __table = SUMMARIZE('Table4',[Item],[Unit of Measure],"__quantity",IF([Unit of Measure]="kg",SUM([Quantity])*1000000,SUM([Quantity]))) RETURN SUMX(__tabl...

Re: disable allow receipents to share your report on sharing report dialogue box

If by disable you mean that they don't even have the option, then I am not aware of any setting that will do that. Your data analysts will need to uncheck the box manually. 

Re: Display Columns Dynamically

So, is this with a Live (Direct Query) source or Import?

Re: DAX Get the Average and Find the Maximum for both the category and the Value

I was worried that would want it as a DaX query but fingers crossed they may be happy with that. Thank you so much. Ill just make sure that they are happy and mark as solved

Store/save matrix values with timestamp

Hi,    The data source is overwritten daily.  I would like to store matrix results (computed with different measures) weekly in order to keep track of some KPI’s, to analyze their ev...

Re: Power BI Desktop error and refresh data cloud

Hi,   What do you mean about the datasource? I'm connecting to Sql Server using some views and it is configured as 'Import Data' not Direct Query. The version of the Power BI Desktop is the f...

Re: returning customer count

did lon lat ltime location Column 1 8.89314365386963 49.2425270080566 2018-08-02 20:58:12 KFC 0 1 ...

Re: cumulative totals between filtered dates

i dont have date but i have a mmm-yy column in text. I have the same mmm-yy column in my calendar table for sorting the time series in all my charts.   i've played with your formula with ...

Best location for Azure Server

Hi there   I'm working with some fairly large Power BI files (just under 1GB) and the time to publish them from my local desktop into app.powerbi.com is not insignificant. To speed that up I t...

Re: Message: We cannot convert the value "[Binary]" to type Binary.

HI @Rockmond,   Is there any advanced query operations in your query tables? Can you please provide more detail information? AFAIK, custom functions and some of advanced operations on...

Re: Bug/error with the New Filter Experience in Power BI Service

Experiencing the same issue. Issue started occuring a few days ago.

How to filter a table visual based on a CrossFiltered relationship in a calculated measure

I have the below calculated measure using a CrossFilter function as below. It is displayed on a card visual. It reduces the total number of rows (grants) correctly, and also updates based o...

Shape Map Advanced Filtering with cards & slicer

Hi, I’m new to this forum and would appreciate your help. I’ve built a report with a shape map, a dropdown slicer and several cards. The slicer allows to select a year and pressing a state shows va...

Re: [intl bash] Typo at email subscription

@hongju, I have reported this issue internally: CRI 103700308, I will  post back once I get any updates. Regards, Lydia

Re: Add parameter to Highest and Lowest value in Matrix and Year format

Thanks for your reply, I am using a new column and adding year, how can I set it to pick the date from my column having dates. Is there a tutorial already available for the measure and conditional f...

Re: Multi Select Slicer

Hi @bipinjha,   I would suggest you create a new post in this forum. It looks like a different scenario.     Best Regards,

Re: Data comparison on two tables in direct query

Hi @Shamar123,   By my tests, you could create the measure to compare the two date from different tables in Direct Query.     Best Regards, Cherry

KPI from survey responses - transform data to make it suitable for KPI visual

Hi All, I would like to ask if you can recommend a way to manipulate the data below in Power BI so it is suitable for a KPI visual: Date Answer 01-Jan-18 Agree 01-Jan-18 Agree ...

Re: DAX Calculation from related table

Thanks @ccapowerbi    But i was not referring to the formatting itself, rather more the logic to ensure it is working efficiently  

Re: DAX Calculation from related table

I can't tell you the best way to write your particular DAX expression. However, since you are interested in optimizing your DAX, sqlbi.com always publish articles about the best way to optimize DAX. ...

Re: Count number of employee in any given week - utilization calculation

Hi, I have managed to recreate this using similar data - unless I have misundersood your question it should be as simple as creating a table and adding to the Values are the following: Week Comm...

access to resource is forbidden

Hi all,   While refreshing power bi dashboard, i am receiving the error message"access to resource is forbidden". My dashboard is connected to both sharepoint and excel sheets.  Please s...

Re: Count number of employee in any given week - utilization calculation

Hello,   My apologies for not explaining. Yest this is the value that I am looking for, however, I would like to get cout distinct on DAX so that I can further use the information to calculate...

Re: Get the previous values of a specific date

Hi @v-frfei-msft,   Thank you for your time in sharing the PBI file. Actually I didn't mention that there should be no filters in the report and it has to pull the latest month. Your sol...

Re: Looking for best possible approach to get data from Service Now to Power Bi Desktop?

Hey @v-cherch-msft,   In get data option of Powerbi Desktop there is no connector available for serviceNow currently. so want to check if there is any way to get the data from serviceNow....