Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@Anonymous , refer if these can help
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |