Forum

Hi Jason, I'm not sure Power BI is the right tool for this what-if analysis. I'd use Excel for this. Maybe it can be done in Power BI, but I don't ...

Hi Amber, It's more efficient to create your date table in Power Query as this removes the need to have calculated columns running in Power Pivot. ...

Hi Angela, In Excel 2016 or Office 365 you are using Power Query. Power Query is the new get & transform data tool in Excel. It's very differen...

Hi John, Welcome to the forum. Can you please upload a sample Excel file with some data that covers all of the scenarios and your desired result. F...

Hi Jeremy, Welcome to our forum! Thanks for attaching your file. If you build a PivotTable and place the Date field in the rows, then expand it dow...

Hi Chris, Formulas do not copy formatting, they only copy the underlying cell value. If you want formatting applied, you need to either do that man...

Hi Claudine, I'm not aware of the cause, but if you're using Excel 2016 then this is known to be unstable with Power Pivot, so maybe the solution i...

Ah, that'll explain it then. If they're in the model then they'll be in the Slicer.

Hi Sean, You can try modifying this lookup and return multiple values formula to lookup multiple sheets, but now that we have Power Query I don't r...

Hi Tracy, The file attached is a .csv and therefore the query and PivotTable have not been saved. Can you please upload your .xlsx file. Thanks,...

This is the question I answered: "my real problem is that when there is no planned date or actual date then it shows #N/A in that particular week.(...

Hi, It looks like the Cashflow sheet is corrupt, because if you insert a new worksheet you can apply the group buttons and they are visible, but in...

Hi Karen, Can you please upload a sample Excel file. It's difficult to visualise what you want and even more difficult to explain a solution with j...

Hi Jon, Ah, I see I left out the final IF so you just need to add another IFERROR(INDEX for F59 That said, I don't think trying to nest every cr...

Hi Jon, Welcome to our forum. Thanks for your question and sharing your file. You could try using INDEX & MATCH in cell J59 like so : =IF...