Power Automate 搜索
搜索
powerquery: need help with REST api
社区I am currently trying to achieve the below with M query - is this doable? any suggestions are welcome.. Thanks in advance This is what I need to be able to do 1. First I need to ...
Row values to column
社区hi! I have a table where a basic row is by milestone (blue table) and I have to rearrange it so that it is by code (black table). Could you please help...
Re: Aggregate lists from SharePoint sites
社区To any one else who needs this I managed to get his working with a two stage approach: 1. Create a list in SharePoint with the names of the subsites that the users can manage 2. ...
Re: how to run REST endpoint in M
社区Assuming that your REST service answers with JSON, you would do something like let Source = Json.Document(Web.Contents("https://api.powerbi.com/v1.0/myorg/gateways/" & GatewayId &am...
Re: Converting string ex. "117:50:00" into hours
社区Its a good point but I converted as date/hour but not worked. After conversion I performed a subtraction and the result was the same. Take a look. Ex. 4.21:50:00 Its a "string" 4days21hours:50...
Fill Dates between dates using custom column
社区Hi could someone help me with custom column ? i have a table let say "Product Rules" with ProductID,Productname, effective_date, Expiry_date something like this: ...
Re: Native query on Oracle use TO_TIMESTAMP function for date fields
社区Hi, Yes the native query is from View Native Query in Power BI, and filter is applied on datetime column. Thanks, Vishal
Calculate present and next value
社区Hey guys 🙂 I want to calculate break between starting date and ending date by only if name are equals. ( 10:16:30 - 10:15:30 = 00:01:00) e.g. Starting ...
Are nested parameters supported ?
社区I am using a template which i used to create reports for multuple customers. I use one parameter for customer name. Based on this customer name ( which i will chose when opening PBIT template) i wa...
Re: Calculate present and next value
社区If you don't know how to use the power query code, I think it's better to "work" in another environment. Excel, for example. I attach the image of the sheet where there are data and formulas ...
Re: measure missing upon reopening
社区did you publish from your Power BI Desktop to a workspace or even an app? In that case you can connect a client like DAX Studio or SSMS and run an MDX query against the Measures table. Selec...
Re: Relacionamento Composto por 3 Campos/Atributos
社区Hi @spfcbr If any of the answers sloved your problem, could you kindly accept it as a solution to close this case and help the other members find it more quickly? If not, please feel f...
Re: New Measure - Count number of entries that occur X% times
社区Hi @Anonymous Measure = VAR _30pc_ = 0.3*COUNTROWS(Table1) VAR auxt_ = ADDCOLUMNS(DISTINCT(Table1[Name]), "Count_", CALCULATE(COUNTROWS(Table1))) RETURN SUMX(auxt_, IF([Count_] > _30p...
Re: How to use list.contains from another query
社区You just have to know the syntax @cheryl-lee33 which means visiting the MS pages quite often. Table Column: Table.Column(table as table, column as text) as list So it is asking for ...
Re: How to speed up merge in Power Query when use a NestedJoin?
社区Can I add an Index Column, does that accomplish the same goal?
Re: Sum one column and then divide against the count of another column
社区Ricardo, Thank you. The synax worked, but it produced an error in the cell stating that it can't find column [Open]. I merged it as a query from another source, so the top is listed as...
Re: How do I use table.buffer to speed up a query? (How do I create M code for table.buffer?)
社区Thanks, how do I determine if my table is small or big? E.g. I have a table that is 1.2 million rows with out 25 columns. Would that be too large for table.buffer?
Re: Expression.Evaluate with List.MatchesAny
社区Hello @Smauro I have applied your 2a solution and... it works!!!!! Thank you very much 🙂
Re: How do I use table.buffer to speed up a query? (How do I create M code for table.buffer?)
社区Hi @Anonymous Table Buffer is not a magical function that will make every code run faster, it is beneficial in situations where you have small tables that you have to reiterate ...
Re: If cell is blank, add value from another column
社区Hi @Out4uv8 Try this = if [L9] = "" then [Name and Position] else [L9] Best Regards, Mariusz If this post helps, then please consider Accepting it as the solu...
Re: Sum one column and then divide against the count of another column
社区@Out4uv8 , Can you explain the logic with an example using this data, please ?
Re: Sum of values in one query based on filter from another Query
社区Thank you. This worked perfectly 😀
Re: DAX Query taking longer time
社区For your first one, I haven't seen KEEPFILTERS() used that way, and don't think it is doing anything. VALUES should be honoring any relevant filters anyway. In any case, you have some ...
Re: Convert rows to columns pivot while joining two tables - Power BI
社区Hi @anapowerbi You can pivot your Table B with the setup as below. Later just Merge the tables on JobNo Also, see the attached for the ref. Best Rega...