Conversion for Excel formula

  • Is there a way I can convert the following excel formula into either a parameter or filter the data at sql table level. This is working perfectly if I download the tables from our database but I can not see how to acheive the same thing in either SSRS or SQL

    Thanks

    Chris

    {=INDEX('Live Intranet Based Billing Targets.xlsm'!Periods[PeriodId],MATCH(1,IF('Live Intranet Based Billing Targets.xlsm'!Periods[PeriodStartDate]<=TODAY(),IF('Live Intranet Based Billing Targets.xlsm'!Periods[PeriodEndDate]>=TODAY(),1,)),0))}

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply