How to populate the custom measure with historical values from a custom field

Questions & Answers
1

Hi everyone!

I have “OKR Quarter” custom field (single-select) with the following options:

  • FY25Q1
  • FY25Q2
  • FY25Q3
  • FY25Q4

I’d like to create a custom measure “Carry-over” and populate it with all historical values from “OKR Quarter” field. For example, if the value in “OKR Quarter” field has been changed from FY25Q1 to FY25Q2 and then from FY25Q2 to FY25Q3 I expect to see the following in the custom measure: “FY25Q1, FY25Q2”.

Could you please suggest how I can do that within the eazyBI? Thanks!