m language

Hey everyone, I am trying to add a new 24-hour time column to a one column table that contains only dates. The Date column is dynamically pulled from a database that provides dates for 30 days into the future. I am doing projection work, so there is no original time column for me to pull from...

Hello; I am cross-posting this question from SO. I'm using an API (for a project management database) that returns a result in the following form (in JSON format): {'Content': { 'Projects': ['project1', 'project2', 'project3', 'project4'], 'InvoiceGroups': ['group1'...

Trying to use run the Regex trick (that members Grah and Bo_Ry skillfully adapted for this case), I run into a problem which might have to with my worksheet not being a table. The error text is: Expression.Error: The field 'Comment' of the record wasn't found. Details: Name=Sheet1 Data=...

I get a token literal expected error, not sure what I am missing. It highlights the ' o" ' part of the No =if [UPC]= <> "No" then "Yes"[UPC] I am trying to change any value that is <> than "No" to be "Yes" also tried =if [UPC] <> "No" then "Yes"

Hi all, I'm trying to create a column in power query editor that looks at a date and inserts 'exclude' if it's after 1Apr2020 and inserts 'include' otherwise. The editor, however, says using <= or >= doesn't work for dates. What expression should I use instead? Todd

I have loaded a simple flat file I have pulled into a query. The data looks like this: <tbody>#DAE7F5[/URL] "] A B C D E F 1 Broad Identifier Specific Identifier Candidate Candidate Score Qualifier Candidate Score Evaluation, Desired Outcome 2 9 9.333 9.111 0.222 3...

How to convert below excel formula to DAX? =IF(ISERROR(AVERAGEIFS('P'!$U$3:$U$2186,'P'!$H$3:$H$2186,'C'!$I2,'P'!$X$3:$X$2186,'C'!$C2,'P'!$F$3:$F$2186,'C'!$F2)),"No" =IF(ISERROR(AVERAGEIFS(UP,MAT,MAT,WORLD,PLANNING,LINE,LINE)),"No"

Please see below scenarios and provide your suggestions, My data source is in Oracle to power bi and as per my requirements I need to compare order no rows, if order number has .1 then I need to find order number without .1 and delete both rows. Does any one has any suggestion...

Hi all, When I create a calculated field in Microsoft Power Query feature ("Get and Transform" since Excel 2016) I use a combination two simple formulae: Value.Divide() and Value.Add(). For some reason, this does not work and all I get is null values. Here is the series of steps that I...

Hello everyone! I have a query here wich contains 10 different columns. I need to create 4 other columns (A B C D), with formulas that contains values from this 10 first columns. One of my inicial columns is called "Period", and it starts in 1. So, when period is equal 1, colunm A is...

Hello Any help here appreciated. In M, I am trying to reference a numeric value in a column as the number of characters to split a column by, but I am not sure how to do this. The value I want to split by is in Column 5 and the Column I want to split is Column1. I came up with this...

I have a folder of files that I am querying for the files' date modified, file size, and a few other attributes. Long-story-short we have multiple versions of these files in subfolders and each "release" we make a new folder and copy the Excel files into them. So I created this query that can...

I want to fetch data from Google Analytics With M (PowerQuery/PowerBI), but want to filter the dimension values on the fily, Let's Say my dimension is "Page" and I want "Pageviews" and "Unique Pageviews" measures, provided that the "Page" is following a regex filter (ex...

Is there a way to split by space as a delimiter but only if the space falls between a number? So you got some poorly formed excel that has all the data in one column an example I created this. Because if people have different or hyphenated names then that will throw it off so if we can get...