Forum

Hi Patrick, I've been giving this some thought, hence my slower than usual reply. I think the best option is to have two tables, Table A contain...

Hi Patrick, Welcome to our forum! You can create an income statement with Power Pivot and some trickery as described here. I hope that points...

Hi Andrew, Welcome to our forum! You can use the data profiling tools on the view tab of the Power Query editor window to show the column qualit...

Hi David, Have you tried using 3D Maps? I'm not sure how frequently you want this map to update, so 3D maps mightn't be ideal. Alternatively, y...

Hi Sanjeev, Welcome to our forum! Can you please upload a sample Excel file that more clearly explains what you're working with and the desired ...

Hi Grace, If you're referring to the Reported Date and Departure Date columns then these aren't even dates from Excel's perspective, they're text! ...

Hi Grace, If you check how many characters in cell A3 on sheet 'Vlookup error' using =LEN(A3) you'll see it returns 7. So you also need to clean/tr...

Hi Pam, Power Query is not the place for formatting. This should be done once you load the data to Excel. You can use a custom number format: 00...

Hi Amel, This will only happen if that sentence is already in a cell above the one you're typing in. It is not a feature of data validation that yo...

Hi Aye, When you use the FORMAT function you're converting the measure result to text. Conditional Formatting can't apply formats based on numeric ...

Hi Steve, Welcome to our forum! Thanks for sharing your file. You can automatically generate a sheet for each resource ID using the "Show Report Fi...

Hi Ramzan, I'm sure it's all possible and will be valuable for SEO. You can use PivotTables to extract the Top 10 based on a value field. I encoura...

Hi Declan, It shouldn't matter if the actuals aren't all on the first of the month. Your one big table might have budget and forecast on the 1st an...

Hi Declan, If you use the "Full Outer Join" (mentioned in the note above) it will bring in all rows from both tables. It will be easier to write th...

Hi Salman, Essentially what you want to do is treat this as another location called 'Best of Network'. To do that you'd have to add it to the rows ...