Forum Discussion

finsmaniac1551's avatar
finsmaniac1551
New Member
2 years ago
Solved

Help with TOTALYTD Formula

Hi everyone, I am having trouble with the TotalYTD Formula, below is by data set, it is in order from latest month at top and most recent at bottom .The column that is not correct is the far right on...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi finsmaniac1551 ,

    Regarding your question, please make sure that the table data is similar to the following data.

    The formula works well.

    Or you can leave out the 'TotalYTD' function for the same purpose.

    Measure 2 = 
CALCULATE(SUM('Table'[Value]),
FILTER(ALL('Table'[Month]),
AND(
    YEAR('Table'[Month]) = YEAR(MAX('Table'[Month])),
    'Table'[Month] <= MAX('Table'[Month])
   )
))

    If in doubt, please share the .pbix file without sensitive data.

     

    Best Regards,
    Wenbin Zhou
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi finsmaniac1551 ,

Regarding your question, please make sure that the table data is similar to the following data.

The formula works well.

Or you can leave out the 'TotalYTD' function for the same purpose.

Measure 2 = 
CALCULATE(SUM('Table'[Value]),
FILTER(ALL('Table'[Month]),
AND(
    YEAR('Table'[Month]) = YEAR(MAX('Table'[Month])),
    'Table'[Month] <= MAX('Table'[Month])
   )
))

If in doubt, please share the .pbix file without sensitive data.

 

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.