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
Icon for Solution Specialist rankSolution Specialist
4 years ago

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Edit: Solved it, needed to the date to be in hierarchy. I guess if I want the same layout as a proper P&L I will need to build it through a P&L logic?