Search

JerryT

Hi All, I'm new to power bi desktop and power query. Now I have a table named ProjectsSummary which contain 5 columns which will be used below: [PN] [StartDate] [MonthsBetween] [MonthlyQty]...

Syndicate_Admin

In a solution in a development environment, I added a column to a table. I then exported the solution as unmanaged and imported it into a pre-production environment. Using Dynamics 365, I was able to...

ozod

Hello, I hope you can help me with a case I have spent hours on. I am struggling with consecutive values where they are spread over several columns. You can access the sample data via ...

CJ3k

Hello! I have been trying to write a code in Power Query that allows me to have a custom column that comes back with either true or false If all of the columns selected in a row are nulls. I know I...

manuelho · ‎09-19-2023

Hi there, i am getting data from Smartsheet and would like to create an incremental refresh. Unfortunately "View native query" is greyed out. I've checked all the other threads in this foru...

CarlBuckley

...ype text}}), DayName = Table.TransformColumnTypes(Table.AddColumn(MonthName, "DayName", each DayList{[DayOfWeekNumber]-1}), {{"DayName", type text}}), //Add a column that returns true if the date on r...

nhodges · ‎09-15-2023

If I wanted to break down my total revenue measure month over month in a table. I dont want to have to add a month each time, so want it to add everytime by itself

LordSnow

Hi everyone, I am trying to add a custom column by comparing a different table. To simplify let's say I have 2 tables (or 2 queries or 2 datasets). One is called June and another is called J...

HC1801

Hi, I don't have much experience with M, and am a new user of Power Query. I've got the above error after running the below code: #"Changed Type2" = Table.TransformColumnTypes(#"Renamed Col...

Tito

Hello, How can I use Power Query to remove the duplicate name from the "Name" column with the condition inactive in the "Status" column? Thank you

Search the Community

Problem happens when I try to expand a record as a...

Custom column added to Dataverse doesn't appear in...

Consecutive values on multiple columns

Help with Formula Regarding 7 Columns Null/True/Fa...

Native Query greyed out

Expression.Error: There is an unknown identifier. ...

How to get measures by month horizontally in a tab...

I would like to add a column to a table by compari...

'We cannot apply field access to the type Number. ...

Dupplicate values with condition