Filtering Issue with end of month

[KG1]

I have 2 measures

The first calculates the end of the month value

EOM =

CALCULATE(

    SUM('All Statuses'[INVOICE_LINE_AMOUNT]),

   ENDOFMONTH('All Statuses'[W/C]))

The second calculates the previous month value using the EOM Measure

End of previous month =

 CALCULATE([EOM],DATEADD('All Statuses'[W/C],-1,MONTH))

When I click on the bar graph the end of month value updates correctly but the previous month is blank

When the 2 measures are not filtered the values are correct

Can you please advise where I am going wrong?

Many Thanks

[Mahesh0016]

Current_Month_Price = CALCULATE(

    [Total ListPrice],

   ENDOFMONTH('Date'[Date]))

previous month =

 CALCULATE([Current_Month_Price],DATEADD('Date'[Date],-1,MONTH))

Hello @KG1 ,

You should change the fact date column with daimation date[date] table.

try it , i hope it will work fine.

[KG1]

Hi

Have done this and the date table is marked as a date table

When I drag the measure into a card the value is blank

It is also picking up the end of October value when it should be the end of November

This means the previous month measure isn't working because the data only goes back to October

 Thank you