5 Replies Latest reply on Aug 9, 2017 5:38 AM by Dhwani C

    Get previous value without Table Functions

    Dhwani C

      Hey guys,

       

      I have an issue with some filters I'm using. If you see in the workbook, I have a dynamic filter for every date level. This works better in some ways than parameters as the filter will update automatically with data refreshes.

       

      I need to get the USD value for the previous month at a row level. Right now, this can be done using a LOOKUP function, but it won't work the moment I apply my month filter.

       

      The client has asked to not use parameters for date selections as they are static and I need this to work with filters. I have a feeling maybe LOD calculations may answer this but I've been breaking my head over this and I'm not able to. I need a calculation that doesn't involve table calculations because I won't always have the month column in my table.

       

      Thanks!