cancel
Showing results for
Did you mean:  Helper I

## how to have current week and previse week

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
1 ACCEPTED SOLUTION Frequent Visitor

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") Frequent Visitor

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