8 Replies Latest reply: Dec 9, 2016 9:22 PM by Sunny Talwar RSS

    OLE BD - ACCESS BD - Formula to only count today's entries

    Dean Vincent

      Hi,

       

      Please could i ask for your help...

       

      I have created a DB, that is updated daily but i need to pull the figures out just from today??

       

      The FX i created doesn't work:

       

      Count({$<[Created]>*(<[Import Date]={0}>)}[Import Date])

       

      Created is a field/measure

       

      Import Date is the Dimension

       

      I will then need to create a FX for 28 days and 90 days.... (+  there will be other fields added later)

       

      Any Ideas??