Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

TOTALYTD Question - Different results

Having a question on the way TOTALYTD behaves.    Trying to get a cumulative totals for the monthly total sales  and receipts from the below data   I have a calendar table and relationship ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Did you got the answers, If not please share additional information.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Did you got the answers, If not please share additional information.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-yuta-msft  amitchandak 

 

Thanks amitchandak for clarifying on the YTD function. I took the below approach to solve it.

 

M_Cumulative_Total =
VAR MaxDate=CALCULATE(MAX(Calendar[Date]), Invoice)
RETURN CALCULATE([Inv_total], FILTER(ALL(Calendar[Date]), Calendar[Date]<=MaxDate))