Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi Community,
I am new to Power-Bi and i'm trying to calculate the diference of items on stock based in 2 dates. I get the data irregulary - but I need to know the difference between the dates.
For example - please see the lsit below. I would like to calculate the difference between the days - what is the best way to do this
Thank you very much in advance !!
Hi @oldman_vienna ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @oldman_vienna,
This should help if your data is summarized in the table as above.
https://community.powerbi.com/t5/Desktop/difference-between-rows-of-a-date-column/m-p/620913
Did I help you today? Please accept my solution and hit the Kudos button.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |