Hi Mynda, Thanks but what I meant is inside Power BI. If in the excel the column has a text, it will result to an error when refreshing it to ...
Hi Philip, Yeah I think the pivot might do. Thank you so much.
Hi Philip, Thank you for providing the IF string, that's actually what I need. I'm having problem on multiple and glad someone answered. 🙂
Hi, Can you site a sample in excel for this. SUMIF(Sheet2!B:B,"Americas",Sheet2!C:C) Thanks.
Hi Catalin, Thanks for checking the file. Actually I need to filter to the office slicer as well not only on the month, apologies for not s...
No worries and thanks. I tried changing the text in A2 but suddenly the formulas in B2-D2 became #Name. Even copying the formula on the next row r...