Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi,
We have some data about projects being pulled into a data warehouse and marked with a date for when the data was pulled. We've marked records with the latest data with current_flag = 1. Writing reports has been OK, but now moving it to the service and interacting with Q&A, dashboarding and thinking about some less advanced users working with this data, it might be confusing. What is the typical approach for doing this? Separate tables? Would you then need to prefix fields with current or historical or is it obvious what category of data it is?
Thanks!
Hi @samgreene1 ,
You may refer to the links:
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.