Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Matrix total is not matching

Hi ,    I am trying to work on YTD calculation for net sales from 2020-2022... and I am trying to see that in months and years so When I create the matrx the totals doesnot match... or is there a w...
Need Help
  • danextian's avatar
    danextian
    4 years ago

    Hi Anonymous ,

     

    You can create another measure that will sum the YTD and LYTD values.

    YTD SUM =
SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( Dates, Dates[Year], Dates[Month Name] ),
        "YTD", [YTD Measure]
    ),
    [YTD]
)

     

danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

Hi Anonymous ,

 

You can create another measure that will sum the YTD and LYTD values.

YTD SUM =
SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( Dates, Dates[Year], Dates[Month Name] ),
        "YTD", [YTD Measure]
    ),
    [YTD]
)