0

How to obtain a value from the same day in the previous year

Hi, I'm looking to obtain a value from a measure which shows that value for the same day from the previous year. I have created this below in formulate, however it is returning the same value which the measure already show. Can anyone help with obtaining the value from the previous year. TIA

1 reply

null
    • alex_scott
    • 1 mth ago
    • Reported - view

    , easiest way is to create a date parameter for the current date.  Select the parameter in the formulate then click on the function button for the parameter and add the lag.  

     

Content aside

  • Status Answered
  • 1 mth agoLast active
  • 1Replies
  • 21Views
  • 2 Following