Hi,
I've , been trying to create a running total by category using DAX , I have got it working but would welcome any advice if there's a better way;
I've attached a file show working tryouts and results;
the forumula I ended up with;
< VAR prod = TESTA[Product]
RETURN CALCULATE(SUM(TESTA[Qty]),
FILTER(TESTA,TESTA[Index]<= EARLIER(TESTA[Index]) && TESTA[Product] = prod)) >
Any advice on how to achieve this using M code in P query would be welcome.
Richard
Bookmarks