Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am new to Power BI and I am inexperienced in creating calculated columns and measures.
I have a database that contains dates, vehicle equipment numbers, and km readings from the odometers. So far I have the report below. I need a column that contains the last km reading before the current one and the date associated with it so that we can compare how much the kilometers have increased since the last data entry. I have tried some soultions that I have found on other forums but nothing seems to work so far.
Does anyone have a solution to this problem?
Hi @bbr113 ,
I am not sure what desired result would you want, could you please share your sample data or desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Amy
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |