Current month and previous month on line chart for selected month

[Lolo_2023]

 Hi everyone,

i had a measure to calculate the previous month data, it didn't showing on line chart but it's working on card.

 

what i really want is, when I choose Feb on month slicer, it's show the data for feb and jan 

this is my data table

[tharunkumarRTK]

I think you forgot put your measure definition, there are many ways to do this. Here is one


Var selectedmonth = selectedvalue(Table[MonthNum))
Var prevMonth = selectedmonth - 1
Var last2months =treatas( {prevmonth, selectedmonth}, Table[MonthNum])
Var result = calculate([Measure], keepfilters(last2months))
return result 

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[Lolo_2023]

It works with me , after adding the variable in the beginning 

LastMonthValue = Var selectedmonth = selectedvalue(Table1[Month])

Var prevMonth = selectedmonth - 1

Var last2months =treatas( {prevmonth, selectedmonth}, Table1[Month])

Var result = calculate([Last Month], keepfilters(last2months))

return result

but still didn't show on the line graph 

 

[Lolo_2023]

Error

how can i fix it ?