Power Automate 搜索

搜索

Re: Check duplicate in another table

社区

Thanks a lot, it worked like a charm !

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...