how to have current week and previse week

[Anonymous]

how to have current week and previse week

Current Month =

    var _currnetMonth = MONTH(MAX(Overall[Date]))

    var _currentYear = YEAR(MAX(Overall[Date]))

return

    CALCULATE(SUM(Overall[Hours]),

            MONTH('Date'[Date]) = _currnetMonth,

            YEAR('Date'[Date]) = _currentYear)

thanks 

[Anonymous · Accepted solution]

Here's a really messy way of doing it that I'm sure someone will improve on:
/*calculated table*/
Current and Previous Week Hours = 
var _currentDate = Max('Date'[Date])
var _currentWkStart = DATEADD(_currentDate, -6, Day)
var _previousWkStart = DATEADD(_currentWkStart, -14, Day)
Return Summarize("CurrentWeekHours", sumx(Filter(AllSelected(Overall), [Date]>=_currentWkStart && [Date] <=_currentDate), [Hours])
, "PreviousWeekHours", sumx(Filter(AllSelected(Overall), [Date]<_currentWkStart && [Date] >=_previousWkStart), [Hours]))

Alternatively you could use the variables to create a flag (calculated column) in your date table to identify current and previous weeks 😆 
/*Calcuated Current Week Flag */ Return if(AND([Date] >=_currentWkStart, [Date] <=_currentDate), "Y", "N")
/*Calcuated Previous Week Flag */ Return if(AND([Date] >=_currentWkStart, [Date] <=_currentDate), "Y", "N")