Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
How to calculate if there was a difference between the dates when both are in the same column?
Same item on different dates in stock (I need to know if there has been a change in validity and what the new value is) and also count how many items have changed.
would have to show that 3 items had changed and show the new expiration date
Hi @Faber13 ,
According to the information you provided, what needs to be confirmed with you is: do you want to calculate whether the validade corresponding to the same column in the item is consistent, and if not, count its number?
If I have misunderstood you, please point it out and give me an example. I will answer you as soon as possible. Looking forward to your reply.
Best Regards,
Henry
I want to create a column that only shows the day it was changed (show the new validity) if there is no change leave the row blank.
in that case it would show only these, the rest would have to be empty (blank)
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 76 | |
| 37 | |
| 31 | |
| 29 | |
| 26 |