Conversion for Excel formula

• cmw 66135

  Ten Centuries

  Points: 1272

  More actions

  April 21, 2020 at 4:05 pm

  #3745033

  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))}

  

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  April 22, 2020 at 4:10 pm

  #3745392

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

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