Forum Discussion

maciejsok's avatar
maciejsok
New Member
3 years ago

Calculate function not working

Hi,   why the calculate function doesn't return any values in the 4th column?    
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

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])