Forum Discussion

Paulompm's avatar
Paulompm
Frequent Visitor
9 years ago

Bring data from a specific month to a matrix

Hello guys   I have an matrix that informs the following information:   Product Current sales Last year sales Previous year total sales Product 1                     200,00            ...
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Something like this should work:

 

Current Sales := SUM(SalesTable[Sales])

Current Sales MTD := CALCULATE([Current Sales], DATESMTD(Calendar[Date]))

Current Sales MTD - PY := CALCULATE([Current Sales], DATEADD(DATESMTD(Calendar[Date]), -1, YEAR)))

 

Paulompm's avatar
Paulompm
Frequent Visitor
9 years ago

unfortunately current Sales MTD Is reporting the full-month sale of May not only the MTD. This information is also good but I also need to know the MTD of May last year.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Would it be acceptable to adjust your calendar table to STOP on the last day you have sales?  Then, I think you would get what you want?