Hello:
I have a need to show start of week as Monday's Date unless Monday is a holiday, then Tuesday's Date would be the Start of Week Date.
I also have another measure in DAX showing the previous weeks date with the same criteria. I'll put the measures below.
What appears to be happening is that these two measures(in cards) go blank when viewing the report in Power BI Service.
I'm wondeing if replicating these measures in M code in a Date table would fix the blank visuals in Service?
Thanks for any input on this issue!
Report Start Date =
var _selectedYear = SELECTEDVALUE(Dates1[year])
var _selectedWeek = SELECTEDVALUE(Dates1[Week No.])
var _startOfTheWeek =
CALCULATE(
FIRSTDATE(Dates1[Date]),
FILTER(ALL(Dates1),
Dates1[Week No.] = _selectedWeek && Dates1[year] = _selectedYear && Dates1[Flag] = "WeekStart")
)
return
_startOfTheWeek
PW Report Start Date =
var _selectedYear = SELECTEDVALUE(Dates1[year])
var _selectedWeek = SELECTEDVALUE(Dates1[Week No.])-1
var _startOfTheWeek =
CALCULATE(
FIRSTDATE(Dates1[Date]),
FILTER(ALL(Dates1),
Dates1[Week No.] = _selectedWeek && Dates1[year] = _selectedYear && Dates1[Flag] = "WeekStart")
)
return
_startOfTheWeek
