5 Replies Latest reply on Feb 11, 2019 6:08 PM by Lina Lin

    Comparing with previous month

    Arun Yadav

      Hi All,


      I have a scenario where I have a month drop down filter and for the month selected from this filter I have to display :

      • Current month measure value
      • Previous month value
      • An indicator arrow ( up or down) to show whether current month value has gone up or down.


      I'm able to get the difference using Lookup based formula but its not working if there is no data for previous month. So the look up will check for whatever value is there for any of previous month and will use that value to calculate difference.


      Is there any work around here ?