Need help - to detect changes the in field value in one column in datasource.

[AOD]

Hi All,

I need your help in below requirement,

Requirement - > There is a field in source table as 'Client Visit ' . ( Values - Yes / No )

Report needs to be built  to review the number of records in table whom intially indicated Yes as Client Visit when first refreshed the data  but later after 2nd refresh it was changed to No.

 As part of this report we need to see when its changed from yes to no and no to yes .

Can you please guide me on this how it can be achieved?

Thanks.

[Anonymous · Accepted solution]

Hi @AOD,

If these values directly modify on your datasource records, I don't' think it is possible ot use power bi to trace them. (power bi does not contain a feature to keep the history records, if raw records has been updated on data source side these old records will be replaced when power bi refreshed)

What type of data source are your works? Any hidden logic fields in your data tables? (e.g. create time, update time...) If this is a case, you can trace them to achieve your requirement.
In addition, I think creating a status change table(record id and timestamp) based on the trigger who activated when records insert/update should be a simply way to log and trace your records.

Regards,

Xiaoxin Sheng

[amitchandak]

@AOD ,

refer if this can help you do build that

https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[AOD]

Thanks for reply. I will work only incase of one time refresh. I need to track the changes on  daily basis. I have requested for adition of new field in the existing table to track the previous value.

Thanks for help anyways . Cheers.

[AOD]

Hi,

I followed method mentioned in the link. Union table gives data from both table.

I am just interesed to apped only Difference data.

how is that  possible. ?

Thanks