Last 12 Periods when Period is Data type "Text" and not "DateTime"

[PhreshMan]

Hi all,

Kindly assist with this problem.

My Line chart has an axis with Period & FiscalYear i.e.  P1 2019/20, P2 2019/20 and P3 2019/20. The data type is Text instead of DateTime. 

I am trying to apply fitler to show the last 12 Period from selection. That is, if I select P12 2019/20, I want to plot values from P1 2019/20 to P12 2019/20.

Kindly assist.

Thanks,

Phresh

[V-pazhen-msft]

@PhreshMan 

You could check this article to understand the logic of getting last n month.

Not sure about your model, the sample file is here with PeriodYear Text column as the slicer.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhreshMan]

Hi Paul,

Please excuse the delay in getting back to you.

Below is an additional issue I am trying to resolve.

I am trying to write  the following DAX: 

12 Fiscal Period Rolling = SUM of last 12 Periods, include the current Period. (I am not using Week, Month, Quarter)

TABLE: DATE                 TABLE: SALES      
FiscalPeriod                    Sales                             12 Fiscal Period Rolling
FP1                                   20
FP2                                   60
FP3                                  30
FP4                                  40
FP5                                  10
FP6                                  20
FP7                                 40
FP8                                 20
FP9                                 20
FP10                               50                                  310
FP11                              70                                   360
FP12                              30                                   330

Kindly assist.

Regards,

PhreshMan

[parry2k]

@PhreshMan Based on your input, you are saying you don't have any date column that can help to get the last 12 months? Is this correct? 

[PhreshMan]

Hi Parry2k,

I have two tables in my data model:

Sales                                                         Date

Sales Date  (Date)                                      Date:  i.e. 1/2/2019, 2/5/2019, 26/8/2019 (Date)  

Branch   (Text)                                           Period: P1 to P12 (Whole Number)

....                                                               PeriodYear:  i.e. PI 2019/20, P2 2019/20 (Text)

etc

PeriodYear is used in the Axis.

Regards,