I have a live integration set up from Airtable to Power BI to display sales data. The reporting is shown at a cadence of every two weeks. Certain records may change in status in the gap of the two weeks - and I want to be able to show what has changed in status and $ associated with that record. In order to determine what has changed from initial creation I have created the following fields:
- Created on (Returns date of creation of record)
- Modified Time ( Returns date of modification of specific field of status)
- Changed/No Changed formula field that returns “Changed” or Not Changed based on whether modified time date is greater then created on
I am trying to create a activity field and want to write a formula that returns what that status actually changed from. Any help would be greatly appreciated!!