Calculate if Same column value is same

Hi All,

Please help with below formula building in PowerBI.

if Ticket number is same in previous row then do the calculation else 0.

1 REPLY 1

Take a look at the OFFSET function, and combine with an IF statement.

Helpful resources

Announcements

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

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

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.