Calculate function not working

[maciejsok]

Hi,

why the calculate function doesn't return any values in the 4th column?

[djurecicK2]

Hi @maciejsok ,

 Please consider adding a separate date table to your model for built in time intelligence functions.

https://www.datacamp.com/tutorial/how-to-create-date-tables-in-power-bi-tutorial

[Greg_Deckler]

@maciejsok Probably because it is a single table model that you are working with. You can do a Previous Month calculation using something like this instead:

Value PM = 
    VAR __Date = MAX('Table'[Date])
    VAR __EndDate = EOMONTH(__Date,-1)
    VAR __StartDate = DATE(YEAR(__EndDate),MONTH(__EndDate),1)
    VAR __Table = FILTER(ALLSELECTED('Table'),[Date]>=__StartDate && [Date]<=__EndDate)
RETURN
    SUMX(__Table,[Value])