Forum

Hi Anand, Welcome to our forum! Assuming your table starts in cell A1, you can use this formula: =IFERROR(MATCH(A2,$B$1:$B$17,0),"Not availab...

Hi Mark, I'm having trouble following the scenario. If you want to re-use a query then you can export them to an ODC file; right-click the query in...

Your MAX formula range is incorrect. It should only include the two columns that contain the dates i.e. CG and CN It should be MAX(GC1001,CN1001) n...

You can use COUNTIFS for this, but the PivotTable also gave you that information and kept the same table in sheet 2. You can just remove the 'Item' an...

Hi Saliha, Thanks for the sample file. Try this formula in cell E12: =IF(OR(B12="NYC",C12="NYC"), "NYC",IF(OR(ISNUMBER(B12),ISNUMBER(C12)),MAX(B...

Measures can only work if the data structure is correct and the relationship exists. If you take the Construction scenario and understand how the mode...

I recommend using a PivotTable for this task as formulas are high maintenance and error prone for tasks like this. It wasn't clear what you wanted ...

Hi Saliha, Welcome to our forum. Can you please provide some more information as I'm not following the pattern in your 'Result' column. Mynda

Hi Mo, if this is in a calculated column based on the Date column of Table1, then: =DATE(YEAR(Table1[Date]),MONTH(Table1[Date])+1,DAY(Table1[Dat...

Hi Angela, You need to shift your thinking from the old Get Data process to how Power Query works. When you say 'my data is quite messy, I need to ...

Hi Paul, Ok, I misunderstood because you didn't mention that you'd used Power Query to get the data initially, you just said you used an 'external ...

Hi Cheryl, Queries are attached to the current workbook only. If you want to get the same data in another workbook then you can copy the query across...

Hi Paul, The modern way to get data form an external workbook is with Power Query. With Power Query you can merge/append data in multiple tables an...

Hi Valerie, Your question is difficult to follow without an example file, but you could try an IF formula like this: =IF((J2+(K2/I2)-1)=0, J2+(K...

That wasn't the risk I was referring to. The risk is that you have a formula error, or miss converting one of the values in the first instance. You'd ...