Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Faber13
Helper II
Helper II

difference between dates in the same column

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

 

Faber13_0-1655299107742.png

 

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

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?

vhenrykmstf_0-1655706160026.png

 

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)

 

Faber13_0-1655733092803.png

 

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.