Αναζήτηση 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: 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...