Поддержка Power BI
Поиск
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.