Display last N months and prior year

[stochasticKL]

Hi,

I have a date table connected to a fact table. I was able to create a what-if parameter that I can adjust to display how many periods of data I want to display in a line chart and table (I followed SQLjason's guide here Display Last N Months & Selected Month using Single Date Dimension in Power BI – Some Random Thought...

I am able to display each months data using this measure: 

Sales (last n months) =
CALCULATE (
    SUM ( Sales[Sales] ),
    DATESINPERIOD ( ‘Date'[Date], MAX ( ‘Date'[Date] ), – [N Value], MONTH )
)

Usually, I am able to display last month's data in the current period by just using the parallelperiod function like this: 

Sales last period = 
CALCULATE (
     [Sales (last n months)] ,
     PARALLELPERIOD (
          'Date'[Date] ,
          -1 ,
          MONTH
     )
)

However, when I use this measure, assuming I selected N = 5 periods, I get this table: 

	Jan 2021	Feb 2021	Mar 2021	Apr 2021	May 2021
Sales (last n months)	1	2	3	4	5
Sales last period	1	2	3	4

Instead of this table: 

	Jan 2021	Feb 2021	Mar 2021	Apr 2021	May 2021
Sales (last n months)	1	2	3	4	5
Sales last period		1	2	3	4

Note that I followed, in-essence, the linked guide above.

Thank you.

[amitchandak]

@stochasticKL , Try like this for n months last year

Sales (last n months) last year =
CALCULATE (
SUM ( Sales[Sales] ),
DATESINPERIOD ( 'Date'[Date], MAXX ( 'Date', dateadd('Date'[Date], -1,year) ), – [N Value], MONTH )
)

[stochasticKL]

Hi @amitchandak @ Thank you for your answer. It's doing what you said - n months last year. Which shows something like this:

+-----------------+------+------+------+------+------+------+------+------+------+------+
|                 | Jan  | Feb  | Mar  | Apr  | May  | Jan  | Feb  | Mar  | Apr  | May  |
|                 | 2020 | 2020 | 2020 | 2020 | 2020 | 2021 | 2021 | 2020 | 2020 | 2020 |
+-----------------+------+------+------+------+------+------+------+------+------+------+
| Sales           |      |      |      |      |      | 1    | 2    | 3    | 4    | 5    |
| (last n months) |      |      |      |      |      |      |      |      |      |      |
+-----------------+------+------+------+------+------+------+------+------+------+------+
| Sales           | x    | x    | x    | x    | x    |      |      |      |      |      |
| last month      |      |      |      |      |      |      |      |      |      |      |
+-----------------+------+------+------+------+------+------+------+------+------+------+

 Unfortunately what I would like to do is simply return the last month's value in the current month like this:

+-----------------+------+-----------+-----------+-----------+-----------+
|                 | Jan  | Feb       | Mar       | Apr       | May       |
|                 | 2021 | 2021      | 2020      | 2020      | 2020      |
+-----------------+------+-----------+-----------+-----------+-----------+
| Sales           | 1    | 2         | 3         | 4         | 5         |
| (last n months) |      |           |           |           |           |
+-----------------+------+-----------+-----------+-----------+-----------+
| Sales           |      | 1         | 2         | 3         | 4         |
| last month      |      | (Jan 2021 | (Feb 2021 | (Mar 2021 | (Apr 2021 |
|                 |      | value)    | value)    | value)    | value)    |
+-----------------+------+-----------+-----------+-----------+-----------+

Sorry to have confused you with the terms period and month. I'm also getting errors about post flooding so I wasn't able to reply immediately.

Thank you!