Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to visualize same month last year in matrix

Hi all,   I want a matrix table showing the sales for the selected month and the same month last year.   I´ve created a formula that works fine: Sales (-1 Year) = 0-CALCULATE(SUM(transactions[a...
Need Help
  • JirkaZ's avatar
    JirkaZ
    4 years ago

    Already replied - drop Year and Month on columns and the two measures to the values of a matrix visual

JirkaZ's avatar
JirkaZ
Solution Specialist
4 years ago

The way this is usually done is that you have 2 measures set up - base and SPLY (Same Period Last Year).

Base: SUM(SalesTable[SalesAmount])
SPLY: CALCULATE([Base], SAMEPERIODLASTYEAR(DimDate[Date]))

 

Then you just throw your both measures in the matrix while having the date dimension data on columns (for example).

BanuTK's avatar
BanuTK
New Member
1 year ago

This is great JirkaZ. Can you give me the same measure based on last year date but this time day of week aligned date instead of using calendar date alinged function of sameperiodlastyear? So when I choose 24 Apr 2025 in the row dimension of the matrix visual, it will show the measure based on 25 Apr 2024 data instead of 24 Apr 2024 data in the columns of the matrix. Measure name can be SPLY_dowaligned. 
Many thanks in advance.