Forum Discussion
Solved
earlier - column calculation
CALCULATE (
SUM ( Fact_Table[Freight Base Charge - Order] ),
FILTER (
ALL ( Fact_Table ),
Fact_Table[Transaction_ID] = EARLIER ( Fact_Table[Transaction_ID] )
)
)
I've read some articles, but I'm still having a difficult time wrapping my mind around this column formula. Is it just listing the total for each transaction ID?
Hi eddd83,
Yes, you are right. That's the magic of context. Please refer to power-bi/desktop-quickstart-learn-dax-basics#context,
row-context-and-filter-context-in-dax/,
https://www.youtube.com/watch?v=Nde7lTSrYFU.
Best Regards,
Dale
2 Replies
Hi eddd83,
Yes, you are right. That's the magic of context. Please refer to power-bi/desktop-quickstart-learn-dax-basics#context,
row-context-and-filter-context-in-dax/,
https://www.youtube.com/watch?v=Nde7lTSrYFU.
Best Regards,
Dale