Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreThe FabCon + SQLCon recap series starts April 14th at 8am Pacific. If you’re tracking where AI is going inside Fabric, this first session is a can't miss. Register 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")
)
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 50 | |
| 44 | |
| 44 | |
| 19 | |
| 19 |
| User | Count |
|---|---|
| 71 | |
| 70 | |
| 34 | |
| 33 | |
| 31 |