Forum Discussion

hectormanfredi's avatar
hectormanfredi
New Member
8 years ago
Solved

Acumulate by month

Hello everyone, I really searched here a way to solve my problem and I tried many ways but none of them seemed to work out, so here we go...   This is the table I've got: Date                     ...
  • hectormanfredi's avatar
    hectormanfredi
    8 years ago

    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.

     

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

hectormanfredi

 

Hi, please post a capture of your measure formula

 

Regards

 

Victor

hectormanfredi's avatar
hectormanfredi
New Member
8 years ago

Hello Vvelarde here it is:

 

AccumulatedValue = CALCULATE(
SUM(DW_VendasComDevolucoes[QtdMd]);
FILTER(ALLSELECTED(DimCalendario[Date]);DimCalendario[Date] <= MAX(DimCalendario[Date]))
)

 

  • hectormanfredi's avatar
    hectormanfredi
    New Member
    8 years ago

    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.

     

  • hectormanfredi's avatar
    hectormanfredi
    New Member
    8 years ago

    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.