Forum Discussion
Acumulate by month
Hello everyone, i appreciate you kindness and i'm very thankfull for your help.
I discover a difernt solution.
I edited the query and I referenced my sales table and in the date column I just pasted the date I wanted.
Not sure what you are doing wrong... Are you using your date field from your date table for the month? When you drop that field, it should create a date hierarchy... Just Deselect quarter and day to leave month and year. See screenshot below.
Also, add that same date field from your date table as a slicer. That is how you will be able to dictate your starting point.
That is exactly what im doing... Look:
Hello Vvelarde here it is:
AccumulatedValue = CALCULATE(
SUM(DW_VendasComDevolucoes[QtdMd]);
FILTER(ALLSELECTED(DimCalendario[Date]);DimCalendario[Date] <= MAX(DimCalendario[Date]))
)Hello everyone, i appreciate you kindness and i'm very thankfull for your help.
I discover a difernt solution.
I edited the query and I referenced my sales table and in the date column I just pasted the date I wanted.
Hello everyone, i appreciate you kindness and i'm very thankfull for your help.
I discover a difernt solution.
I edited the query and I referenced my sales table and in the date column I just pasted the date I wanted.
