Αναζήτηση Power Automate

Αναζήτηση

Re: How to change datatype of text 2.0.10.120 to decimal

Κοινότητα

Hi @MDahitule ,   What is the expected output ?

Re: Add 2nd table list to row on 1st table based on common key then expand

Κοινότητα

  here the results of the merge I suggested. seems what you expect except for the issue 200 that you have in the output is not present in the input tables        ...

Re: Sort by column error in Excel power query

Κοινότητα

oh ok. that is different to how power bi desktop works then which just needs the 2 columns to have only unique pairings so 1 is always Monday for instance.   Thanks 

More recent data Microsoft 365 Usage analysis

Κοινότητα

Hi all, I'm currently using Microsoft's ODATA endpoint https://reports.office.com/pbi/v1.0/ to retrieve data regarding office licenses and sharepoint disk space usage. However, this endp...

Re: Need to parse first 19 characters on the line in which a specific string is found

Κοινότητα

Hi @bR851236574  some chars seem to have flown away 😀 . Try changing so that you have:   Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjKNyTM2UYqNBQA=", Bi...

Re: Need to parse first 19 characters on the line in which a specific string is found

Κοινότητα

Thanks for the additional example.  When I put it into my existing query, it created a sub-table which I was able to expand.  It created 3 rows for each existing row record in my existing t...

Re: Need to parse first 19 characters on the line in which a specific string is found

Κοινότητα

@bR851236574    Try this (with my toy example seems to do what you expect. You should carefully check the name of tables and columns involved and eventually change), where I appended my l...

Need to parse first 19 characters on the line in which a specific string is found

Κοινότητα

I need the first 19 characters of the line in which the first string of " (Additional comments)" is found.   The cell contains text with potentially multiple entries of work notes and/or addit...

Re: Removing duplicates based on a criteria

Κοινότητα

waiting for the clarifications on the possible scenarios, ... a more robust solution     let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQ0VNJRy...

Re: Removing duplicates based on a criteria

Κοινότητα

Here is another approach.  I used @Rocco_sprmnt21 M code to get the example data.  His approach is more elegant, and may be more performant, but here it is just in case.   ...

Email address from SharePoint list displaying as an ID

Κοινότητα

Good morning,    I am currently building a Power BI report that displays actions against an owner. Its being built over an existing SharePoint site which has a field called ‘responsible p...

Re: Shopify API - JSON Query Parsing

Κοινότητα

Hi @Tuan  It is best to use power bi to connect to Shopify API and get tables (fact and dimension) directly. If it can't be accomplished, you could create tables from a flat table using...

Re: Removing duplicates from a column, creating new columns for each distinct value

Κοινότητα

Will creating a matrix instead of a table work for you? In the visualizations pane simply select the visual next to the table one. Then add the "Value" column in your example under the Columns and th...

How to Filter Rows in Power Automate based on a Many to Many dataverse relationship

Κοινότητα

I have setup a Many-to-Many relationship between two tables Process Templates and Task Templates in Dataverse.  This is to allow for one task template to be part of many processes and a process ...

Re: How to specify a table where a user can get link URL with Power Query

Κοινότητα

Hi @PbiCeo ,  You could try below M code  let Source = Web.BrowserContents("https://www.wsj.com/news/types/the-americas"), Links = Html.Table( Sourc...

Re: Getting Subtraction from 1 column with certain criterias

Κοινότητα

    "considering that you will run a big data set and you need this calculation take less memory and run fast", consider to try this version which could be more performing. how many...

iRe: Getting Subtraction from 1 column with certain criterias

Κοινότητα

Hi Allison, i think its a incredible approach. However when i tried to calculate the previous price, it doesnt work. Do you mind to check the formula one more time ? i think we need to find the year ...

Re: iRe: Getting Subtraction from 1 column with certain criterias

Κοινότητα

######EDITED############   try using this code power query:     yourTab = Source{[Item="Foglio1",Kind="Sheet"]}[Data], breakTab=(tab as table) => let tabSorted=Table.Sort(tab...

Re: Help

Κοινότητα

Please help on above dax   Can you please guide on above Dax issue

Re: Help

Κοινότητα

yes, I want a power query.

Re: M expression(s) not working in SQL queries during refreshes from Portal (Help)

Κοινότητα

If you haven't changed any credentials between Service and Desktop, it could be that they've added some extra restrictions. Could you try faking it as a param and see if it works? Date.ToText(...

Re: Function convert a number from given base to base 10.

Κοινότητα

Alright, I like this Ideas: 1) you should set base as optional:   (input as anynonnull, optional base as number) =>   2) You could add an extra step to transform the input to t...

Re: Column with number/text for date

Κοινότητα

Hi @diegolima , you should change column type from number to text and then change to date.   To give an idea have a look here:   let Origine = Excel.Workbook(File.Contents("C:\Use...

Re: Excel power query with empty table

Κοινότητα

it's returning a calendar table of stocks due for earning release. The table is empty when there are no stocks due that day. If I understand what you are saying, I should add something that will che...

Power Query Formula

Κοινότητα

Hi!   In column AT I'm looking to create a formula that calculates totals from a different table (Leads) that is connected to this query since column AM on the current table?  Any help?&n...