Forum Discussion
Solved
Help with DAX formula
Hi All, I have a problem that seems relatively easy to solve but I can't seem to formulate the correct DAX expression. Here's what I'm trying to accomplish: Table 1 contains transaction data ...
Hope the below calcualted column formula help....
Mark the ans if ur requirement is met.
stretcharm
Memorable Member
Memorable Member
AlbertoFerrarihas a greate video that explains dax optimisation and he has an example similar to your problem for an open order calculation. He shows a couple of ways to solve this efficiently. Its worth watching it all, but the open order section starts at 49mins.
https://www.sqlbi.com/tv/dax-optimization-examples/