query parameters

[Anonymous]

Hello,

I have a table in my sql server which is the snapshot of the source table. It is archieved everyday using an ETL and an additional column is added for as of date which is the current date.

I want to compare the yesterday's dat with today's data and check how many new records are added and add a flag to the new records indicating new records.

I aslo want the ability to select the date from as of date column as a filter in my report.

Can anyone help me as i have tried multiple approaches using lookup, creating a duplicate table and comparing but evertime the output is not correct.

[amitchandak]

@Anonymous , refer if these can help

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/

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

This only when your dates are not sufficient to come data post-merge.  if data can be compared post-merge, use time intelligence

https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9