Forum

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...

Hi Kelly, Assuming the files are all the same structure i.e. same column headers, then you should be appending the files. You can do this automatic...

Hi Christopher, A sample chart with some dummy data would be helpful to visualise the data you're dealing with. Mynda

Hi Rahul, You can do this with formulas too, however the count of digits used requires splitting the number into separate columns, then using COUNT...