Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have this calc column to only show previous week.
Week Begins on Monday - >
Solved! Go to Solution.
@Qotsa -
It looks good to me. Only difference I see is:
VAR Current_Week = CALCULATE ( MAX ( [Week] ) - 1, FILTER ( vw_ShiftsAll, vw_ShiftsAll[Date] = TODAY () ) )
versus:
VAR Current_Week = CALCULATE ( MAX ( vw_ShiftsAll[Week] ) - 1, FILTER ( vw_ShiftsAll, vw_ShiftsAll[Date] = TODAY () ) )
Maybe you have something else going on that needs to be known?
Proud to be a Super User!
Hey,
this DAX statement works in my calendar tables:
isInPreviousWeek = var someTestDate = today() -7 var SoWDatePrevWeek = someTestDate - WEEKDAY(someTestDate,2) + 1 var SoWDate = 'Calendar'[Date] - WEEKDAY('Calendar'[Date],2) + 1 return IF(SoWDatePrevWeek = SoWDate, 1,0)
Basically I use this statement to flag some days in my calendar table with flags like
-1 for the previous week
0 for the current week
1 for the upcoming week
Regards,
Tom
Hey,
this DAX statement works in my calendar tables:
isInPreviousWeek = var someTestDate = today() -7 var SoWDatePrevWeek = someTestDate - WEEKDAY(someTestDate,2) + 1 var SoWDate = 'Calendar'[Date] - WEEKDAY('Calendar'[Date],2) + 1 return IF(SoWDatePrevWeek = SoWDate, 1,0)
Basically I use this statement to flag some days in my calendar table with flags like
-1 for the previous week
0 for the current week
1 for the upcoming week
Regards,
Tom
@Qotsa -
It looks good to me. Only difference I see is:
VAR Current_Week = CALCULATE ( MAX ( [Week] ) - 1, FILTER ( vw_ShiftsAll, vw_ShiftsAll[Date] = TODAY () ) )
versus:
VAR Current_Week = CALCULATE ( MAX ( vw_ShiftsAll[Week] ) - 1, FILTER ( vw_ShiftsAll, vw_ShiftsAll[Date] = TODAY () ) )
Maybe you have something else going on that needs to be known?
Proud to be a Super User!
User | Count |
---|---|
93 | |
83 | |
77 | |
70 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |