generate a one-column table that contains hundreds of different categories using M or DAX...
Read MoreOverwrite values in one column with values from another unless null PowerQuery...
Read MoreTransposing (or pivoting but not aggregating) a name/value column pair...
Read MoreHow to solve Expression.Error in this code...
Read MoreAdding Columns using Power Queries in excel that copy the first row of the next column...
Read MorePower Query - extracting data from nested lists...
Read MorePower Query - Loop to extract text between delimiters...
Read MoreCOUNTIFS Equivalent for PowerQuery in Excel...
Read MorePromote headers inside column containing tables...
Read Morestrange DataFormat.Error: We couldn't convert to Number. Details: nan...
Read MoreHow to specify array element based on a value in Power Query for JSON...
Read MorePower Query custom column with M calculating % with null values...
Read MorePower Query M - Way to dynamically use Table.ColumnAdd using value literals to substitute for column...
Read MorePower Query showing error with IF logic (Token Eof expected error)...
Read MoreCalculated columns bases on the past 3 months in Power query...
Read MorePower Query to Convert List of Links to Grid of Crossings...
Read MoreHow do you turn an accumulating number over time into the delta per time period in M (Power Query)?...
Read MoreHow to count number of projects that got approved or the status changed in DAX...
Read MorePower Query only load first 20 columns...
Read MoreCustom Function Power Query (M) - Return Table...
Read MoreHow to "convert" DAX code in M code: delete rows in calculated colum...
Read MoreCreate unique records from intervals powerquery...
Read MoreWhat is the opposite of EOMONTH() in Power BI (DAX)...
Read MoreHow to decodeURIComponent? (ex: "%2F%3F%26%3D" -> "/?&=")...
Read MoreMerge queries matching on dates and leave null if no match found...
Read MoreIs there a simple way to parse comma separated Key:Value pairs in Excel, Power Query or VBA if the v...
Read MoreCountIF/number of occurences column in PowerQuery...
Read MoreConvert categorical variables to numeric PowerQuery...
Read MoreWhen using Queries.Add: How do I reference to a custom function inside the formula argument of Queri...
Read MorePower BI - Does October 1st Fall Between Two Dates...
Read More