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



    {=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 1 (of 1 total)

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