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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
JW_PBI_fan
Helper I
Helper I

Return sum of column for every day after yesterday

Hello again dear community!

I am trying to figure out how to return the sum of a column.  The values included in the sum should only be from today onwards. 

For example, I want to see what transactions will be leaving my current supply. Then, I would say give me the sum of all outbound shipments with a date after yesterday.

I have a feeling that I am over complicating this, but I am having a really hard time figuring out the solution. 
Thanks in advance!

1 ACCEPTED SOLUTION
KriZo
Resolver II
Resolver II

Since no sample data is produced, this is just an example. But you should be able to work your way out from it. 

CALCULATE(
SUM(the column to sum), 
DateColumn >= FORMAT(TODAY(), "DD/MM/YYYY")
)

 

View solution in original post

1 REPLY 1
KriZo
Resolver II
Resolver II

Since no sample data is produced, this is just an example. But you should be able to work your way out from it. 

CALCULATE(
SUM(the column to sum), 
DateColumn >= FORMAT(TODAY(), "DD/MM/YYYY")
)

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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.

Top Solution Authors
Top Kudoed Authors