Forum

Hi Peter, Here is the original post and answer. Note: even with Office 2021, you still don't have this functionality. It's only available with ...

Hard to say without seeing the file, but have you tried fully qualifying the column name with the table name e.g.: =MEDIAN(Table[column]) If tha...

Hi Farah, You can use Power Query assuming your example is consistent in that each section's name is split by an underscore. If so, please see exam...

Hi Darren, Thanks for sharing your file, however it's not clear to me where the formula is that you're having trouble with as the MATCH sheet appea...

Hi Ayanna, Welcome to our forum! If you go into the conditional formatting manager you can see that the yellow format is applied to one cell: K8. Y...

Hi Darren, Welcome to our forum! Can you please upload a sample Excel file that illustrates the data layout and desired result so we can help you. ...

Hi Dieneba, I think you're overcomplicating things. "If I understand well here the dimension is the subcategory of the foreign key on the fact t...

It's because of this: "...BUT you must also have the Completion Time field in the row labels." i.e. the Completion Time field must be in the row...

Hi Richard, Dates in the row/column labels cannot be formatted as you want. However, if you also put the Completion Time field into the Vaues area ...

Hi Syed, It's difficult to answer without an example file, but you might find these tutorials helpful: Excel PivotTable Show Values As • My Onli...

Hi Kelly, If the number of periods will be variable, then the DATEADD function may be what you need. I don't recall ever appending instead of me...

Hi Lisa, Yes, they should be able to refresh the query. Mynda

Hi Lisa, I wonder if it's less about the asterisk and more about it simply having a different name than what Power Query is expecting. You could te...

Hi Dieneba, 1. Correct. The fact table contains the transactional data. 2. Time on site is a transaction type of data, not a dimension. Dimensio...

Hi Ruth, I would avoid links to external workbooks. Instead, use Power Query to bring the data into the file containing the Pivot Chart. Regardi...