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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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!
Solved! Go to Solution.
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")
)
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")
)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!