Forum

Hi Francis, I'm a bit confused. You don't have any amounts in the transaction table on the 1/1/2020 and there are no prior amounts to that date. Yo...

Hi Ronak, Please don't re-quote my reply that is immediately above your reply. It wastes everyone's time having to re-read the same information. I'...

Hi Trond, You're asking Excel to show you the UBW Amounts classified by Type, but the UBW table doesn't have a Type column, and the related uniqVAT...

Hi Ronak, Welcome to our forum. Next time, please provide an Excel file containing your data because when I copy and pasted it to Excel I had to wa...

Hi and welcome to our forum. I think you should approach this from a different angle. If you already had a flat table, this is essentially your fac...

Your file doesn't show me what you tried. I don't want to do it for you, I'd like to see what you tried, because then I can teach you where you went w...

Hi Nick, Welcome to our forum. If you want to filter by multiple year parameters you need to create a list containing those years, then you can ...

Hi Sakti, Welcome to our forum! The WORKDAY.INTL function is simply adding the days complete to the start date but skipping weekends. If you don't ...

Correct. With Power Pivot the cache is the Power Pivot model and it's far more efficient at compressing data than the pivot cache for regular PivotTab...

Hi Norine, Welcome to our forum! First you need to unpivot your data so that it's in a tabular format. Then you need to group the hours for each...

As long as you're loading the data into Power Pivot (as opposed to the Excel worksheet) it should be ok to handle the volume. You can think about i...

You can't select one month in a Slicer and have Excel know which prior 12 month period you want displayed without also selecting the year. The addi...

Update from Microsoft, it is a bug and they'll look into it. In the meantime you can use a custom theme, but that requires you to create the visual in...

Hi Kym, Welcome to our forum! I would use Power Query to bring in all of the data and then use Slicers to allow the user to select (filter) the ...

Hi Nawaf, There's no way to do an incremental refresh in Power Query in Excel. It is available in Power BI though: Power BI Incremental Refresh. ...