Forum

Hi Kondempudi, Welcome to our forum! Your SUMPRODUCT formulas have spaces, not blanks. i.e. your formula is like this: =SUMPRODUCT((I4:I38=" ...

Then use Catalin's suggestion and add a conditional column with a logical test for a number: = if Value.Is([Period End], type number) then null els...

Hi Luna, Are you clicking the 'Refresh All' button or refreshing each query individually? I'm asking because that error shouldn't appear if you're ...

Hi Jess, Welcome to our forum! Power Query tables don't support data validation. The query owns the table and anything that goes in that table m...

Hi Lea, In Power Query for Excel here is only a connector for SAP HANA databases. I don't use SAP, so can't speak from experience, but there are so...

Hi Aye, In the second example cell type null over the top of the faded 43739 value and it will fill down correctly. i.e. you need to give it the fi...

Use the 'Column from examples' button. It writes the formula for you. Session 4.20.

Hi Garrett, Welcome to our forum! You need to split your data out over the months it relates to. You can then plot the monthly data in your char...

Hi Aye, Add a column that extracts the text and ignores numbers. You can use the Column from examples to extract the text values. When you give it ...

Hi Scotty, I don't have a lot of experience embedding Excel charts in PowerPoint, but another option is to add a 'Data Table' to the chart itself. ...

Sorry, missing parenthesis after DAY: =FORMAT(DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY())),"MMMM")

Looks like a limitation of the version of Excel that you have. You can try updating Excel to see if you get the new Power Query ODC export connection ...

Hi Sol, Welcome to our forum! The fix is easy...remove the double quotes from the 1 in your 'value_if_true' argument. i.e. this: =IF(([@BARCO...

Hi Anand, I took your 'Input' table and pasted it into cell A1 of an Excel worksheet. I then put the formula in cell E2. It works to return your 'r...

Hi Mark, In regards to your original question, it sounds like you missed the first step of actually creating the ODC file: right-click the query in...