PowerPivot

Hi Joanna,

Thank you for the forum question.

You will need a SQL string to do it, but it depends on your source where to write the SQL.

If you source is a database you will do it in the connection wizard, if it is a Excel workbook you will have to do it, like we did it with the forecasting model we did on the course.

The SQL string: (If it is from Excel Workbook)

"Select * from `filepath`.`sheetname$` where "your date column">=DateSerial(Year(Date())-1,Month(Date()),1) and "your date column"<DateSerial(Year(Date()),Month(Date()),0)

The SQL string: (If it is from Database)
"Select * from `Name of table` where "your date column">=DateSerial(Year(Date())-1,Month(Date()),1) and "your date column"<DateSerial(Year(Date()),Month(Date()),0)

I hope this makes sense




Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector