I am brand new to PowerQuery. I want to make a custom column with a value of 1 if the column value is in a set of numbers (e.g., 3,6,9,14) and 0 otherwise. Besides a big if statement for all the ...

I am looking for a formula that will count the number of days based on a start date. I have got it to count but the output is not what I expected.

The power query code shown in the link below helped me to pick some particular tables from PDF and format them properly. Import Various Tables with Different Formats from PDF into Excel The problem I ...

I m trying to concatenate a column containing SKUs that don t follow a pattern (some fields with numbers only while others with both text and number) and another column which contains only text. Does ...

I am pulling data from the internet right now and formatting it into a readable list using power query, but I am running into an issue. When I split the columns into rows (as I have to change the data ...

I need your help with some Power Bi code As you can see, in the Excel Worksheet i have 2 cells (yellow) that are mainly of subtotals and 2 columns (last 2) that depends of these subtotals, however ...

Why is my time intelligence measure not returning any results? This measure returns results: Activity = COUNTROWS(FILTER( Inspection Data , [Inspection Type] = "Safety Activities")) ...

I can t seem to find any solutions when searching Google or Youtube. I have an Excel workbook with tables linked to SQL stored procedures via Microsoft Query connections. I ve added columns to the ...