Supporto di Power BI

Cerca

Re: calculate account gp

you can create a measure like: Measure0 = divide(        calculate(sum(accounts[amount]),accounts[account code] =  15999, accounts[company] = 0),       ...

Re: Calculate the difference between two columns in matrix

can you share the layout of underlying data table?

Using PATH(), How Do I Remove Blanks From My Hierarchy Between Levels?

Hello awesome communty!   I'm learning the PATH() function, what I'm doing is, I want to create a product category hierarchy, I'm getting a table from Dynamics 365 F&O called "RetailProduc...

Re: Total average

Hi Frank   Sorry for my late reply    The real data is confidential, therefore I made a quick BI with sample data, and tried to build up almost the same scenario. Link to BI Test ...

Re: How to implement Row Level Security in Power BI Embedded?

Thanks for your response.   I am using User-Owns-Data to implement my requirement.   I have successfully implemented displaying reports list based on workspace/group id and able ...

Re: Disable cross filter direction DAX

@Greg_Decklerthank you for respons. I did it like this with ALL. I addded new DAx table and new cross fileter single connection And I get it OK, but I was wondering is there a way to do tha...

Group by category calculation

Please help me to find correct answer: Fact Table: FactStudent SchoolId StudId InSession   S1 11 5 SchoolLevelP = DISTINCT COUNT(StudId (NOTE: Those are in insession ...

Re: DAX Calculation

You can expand out your rows in Power Query using something like:   #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each List.Dates( [Initial Date], Number.From( [Final Date...

Re: Display value from Column

So, a column form of this would be:   Column = SWITCH(TRUE() ISBLANK([Order No]) && ISBLANK([PO No]),"Unprocessed", ISBLANK([Order No[), [Po No], [Order No] )

DAX and table structure/relationships advice

Hi   I'm building a portfolio reporting tool which monitors financial spend on projects. Part of my data model includes the three tables shown and described below:   Project details - m...

Re: Hiding visual resets filter?

Hmm, will have to test. To be clear, you don't want the filter to be reset, correct? I would think you would need the data checkbox checked for that...

Re: Data Gateway not found

Did you install Personal or Enterprise. If Personal, are you logged in with the same account in the Service that you installed/registered it? If Enterprise, same question or have you given the u...

Re: RANKX issue: dynamic index column with multiple filters

Hi Greg, First of all thank you so much for always answering my questions     I managed to create the index via measure below: Rank = rankx( ALLNOBLANKROW(Table[Agent]), cal...

Re: Retain file name column when using Folder as a data source - Power Query M

Hi @ImkeF,   I am doing something a little bit different and was wondering if you could help guide me in my use case. I have a SharePoint folder where different CSVs will be uploaded with...

Re: Can't refresh data after appending queries which are from different data source kinds

@Ross73312   @Simon_Hou-MSFT   Hi again Ross and thanks for the fast reply,   The root cause why I am using Personal GW instead of On-premises GW is because I cannot use On-...

Matching data

Hi,   I am not sure if it is possbile in Power BI, however is there a way I can match the following:   Colunm A has : W345678-New  Colunm B has : 45635 | W345678   As&nb...

Re: Dividing two columns in matrix visualization

having a separate date table will actually save space and allow you to you use built in time itnelligence, cause for each date you store Year, month etc. only once and not per each row of your datase...

Drill-Down in Power BI webpart for Sharepoint Online

Hello everyone   I've slaved away over my dataset to create some flash drill downs, which i think look great.   I've published it to my Modern Sharepoint site, and I can't access the dr...

Re: How can I create a simple index column with dax.

I created a calculation called Sequential once, but this is going to depend on what is in your table, can you share that or an example?   https://community.powerbi.com/t5/Quick-Measures-Gall...

Re: Date Slicer Between has "wrong" values

Is it in the proper date format, please change it to year.

Re: Return Value based on Multiple Distinct Values in different column

See if this works:   Column = VAR __table = FILTER(ALL('Table18'),[Unique ID] = EARLIER([Unique ID])) RETURN SWITCH(TRUE(), CONTAINS(__table,[Payment Types],"Payment Scheme"),"Payment S...

Re: Values do not appear

Try setting your x-axis to Continuous and your Label density to 100%

Re: Personal Use of Power BI

The way it is setup is really unfortunate, and ridiculous. I certainly hope they rethink the business model and allow individuals to use this tool at an individual (not school or work).

Re: Query editor bug: list may be incomplete

OK, so then when you reload all of the data and you are NOT using an RLS role, then all you see in the data itself if you go to the data model and sort the entire table is -1 and 4? You don't see any...

Re: RANKX issue: dynamic index column with multiple filters

So you want a solution in Power Query? In DAX you would use RANKX. In Power Query you would ask for a lifeline from @ImkeF.