Forum Discussion

llinasG's avatar
llinasG
Frequent Visitor
2 years ago
Solved

Running total values include in blank rows

I am calculating running totals for PO table grouped by week no-YY   Running total PO QTY = CALCULATE( [SUM of QTY (tonnes)], FILTER( ALLSELECTED (PO), PO[Week_No_Year] <= MAX(PO[Week_No_Year])...
Need Help
  • llinasG's avatar
    llinasG
    2 years ago

    Thanks for the help I managed to resolve it. I changed the source week no to date, removed additional week no table and linked all my data tables to one date table and this seems to solved the issue.

llinasG's avatar
llinasG
Frequent Visitor
2 years ago

Thanks for the help I managed to resolve it. I changed the source week no to date, removed additional week no table and linked all my data tables to one date table and this seems to solved the issue.