No Date Table or Date Column and user wants to see last 6 months data.

[tejapowerbi123]

Hello Community,

I have a unique requirement, In the dataset, I do not have date columns, but the user wants to see only the last six months' data.
In February, a user wants to see data from February to the last six months, February to October.
I do not have a date table in the dataset.
***User wants does not want to use any filter or slicer.

Raw Data Set
Month Name	Amount
Jan	10
Feb	20
Mar	30
Apr	40
May	50
June	60
July	70
Aug	80
Sep	90
Oct	100
Nov	110
Dec	120

Final Result
Month Name	Amount
Jan	10
Feb	20
Mar	30
Oct	100
Nov	110
Dec	120

[Tahreem24 · Accepted solution]

@tejapowerbi123 ,

It's little tricky as you want  to Data from March,Feb,Jan,Dec,Nov, and Oct if the latest month is Feb. So as per your need I developed DAX. 

First create Month No. Column as you don't have proper Date column.

Month No. = SWITCH(TableName[Month Name],"Jan",1,"Feb",2,"Mar",3,"Apr",4,"May",5,"June",6,"July",7,"Aug",8,"Sep",9,"Oct",10,"Nov",11,"Dec",12)

Then create measure like below:

Measure = CALCULATE(SUM(TableName[Amount]),FILTER(A,NOT(TableName[Month No.]>=7-TableName[Month No.]) || TableName[Month No.]>=19-MAX(TableName[Month No.])))

So, you'll get below output as per your need:

[amitchandak]

@tejapowerbi123 , do you have a year. because without that how to work on last 6 month

With month and year, you can create a date

Date = "01-"&[Month] & [year] //change data type as date.

Now you can use relative date filter.

[tejapowerbi123]

Thank you so much so for your suggestion Amit.
Certainly I can add a year column,
 Do you want me to create a new Date table or a new calculated column?

Jan:Date = "01-"&[Month] & [year]

Feb:Date = "02-"&[Month] & [year]

March:Date = "03-"&[Month] & [year]